Results 1 to 7 of 7
  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    restoring toolbars (Excel 2000)

    A co-worker ran some workbook which somehow deleted the tool bar "Worksheet Menu Bar". That's the one with File-Edit-View-Insert...

    Now he's trying to run my program which uses that same tool bar to add a custom menu item. Of course he can't see my menu item since he can't get that tool bar to appear.

    How can he get Excel to reload that built-in tool bar? I didn't think you could delete those. I had him go to the Customize list but "Worksheet Menu Bar" doesn't even show up in the list and doing Reset does nothing as far as bringing it back.

    Can I do something in VBA that will restore it? <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>

    Deb <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: restoring toolbars (Excel 2000)

    Right click on an unused portion of the tool bar area. In the Dialog box click on the Toolbars tab. If the Worksheet menu bar is in the list, click on it to select it then click on the Reset button.
    Legare Coleman

  3. #3
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: restoring toolbars (Excel 2000)

    Ahhhh, but that's the problem, it does *not* show up in the list. Somehow that other mis-behaved program deleted it. The [Reset] button was my first choice too but there's nothing to reset.

    Is there some VBA I can write to get it back?

    Deb <img src=/S/eyeout.gif border=0 alt=eyeout width=15 height=15>

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: restoring toolbars (Excel 2000)

    You could try the following, but if the Toolbar was deleted it probably is not going to work either:

    <pre> Application.CommandBars("Worksheet Menu Bar").Reset
    </pre>

    Legare Coleman

  5. #5
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: restoring toolbars (Excel 2000)

    Yeh, I tried that too. No luck!! I thought that you couldn't delete the bult-in tool bars??? At least that's what I've read in many books.

    I guess the only solution is re-install of Excel.

    Thnx, Deb <img src=/S/beep.gif border=0 alt=beep width=15 height=15>

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: restoring toolbars (Excel 2000)

    In case you haven't re-installed Excel yet, try the following before you do that:

    Excel stores modifications to toolbars in a file with extension .xlb. The exact name and location depend on the user login name (and on the version of Excel).
    Do a search for *.xlb and rename or delete the file.

    or

    Hold the shift key down while launching Excel.

    or

    Run the following commands (in Start/Run... or in a Command Prompt window)
    <pre>"C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Unregserver</pre>

    <pre>"C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Regserver</pre>

    (you may have to replace C:...Office by the path where Excel.exe is installed on the PC)

  7. #7
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: restoring toolbars (Excel 2000)

    Hi Deb,
    Have you tried running:
    Commandbars("Worksheet Menu Bar").Enabled = True
    I don't think disabled toolbars appear in the list on the Customize menu so you may just need to re-enable it.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •