Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Victim of my tinkering! (XL2000 SR-1)

    I think I clicked on tools|options and turned off my menus...

    Now when I start Excel, I get the tool bar and the formula bar but I'm missing the File - Edit - Etc menu. & no way to click on Tools|Options to turn it back on.

    Going mad...
    - Ricky

  2. #2
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Victim of my tinkering! (XL2000 SR-1)

    Hi Ricky,

    When you say "I get the tool bar and the formula", which tool bar are you referring to?

    Sounds to me like you might have disabled the Worksheet Menu Bar.

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Victim of my tinkering! (XL2000 SR-1)

    The toolbar with all the buttons is immediately under the title bar. And the formula bar (where you can see range names and edit cell contents) is just beneath the tool button bar.
    File - Edit - Format - Tools - Help, it's all gone!

    - disabled the Worksheet Menu Bar. - is probably right, but how can I get it back? This is the condition of any file that opens, i.e. Book1
    - Ricky

  4. #4
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Victim of my tinkering! (XL2000 SR-1)

    Sounds like the one with the buttons would be the formatting bar...

    If you can open any workbook which starts with some code and get into the VBE with Ctrl-Brk, or trip up some code in an unlocked VBA project and get into debug, you could run the code I posted in the text file earlier.

    <pre> Application.CommandBars("Worksheet Menu Bar").Enabled = True
    </pre>


    There may be some other solutions out there, but I cannot think of any others right now.

  5. #5
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Victim of my tinkering! (XL2000 SR-1)

    Mike - One of the buttons on my toolbar (which was a custom toolbar) was a shortcut right into VBE. I placed the line of code into a module Sub Menu(), came back to the sheet and used another toolbar button (macro button), put it on the sheet, attached the new macro (MENU) and S H A Z A M !!

    Now, I have a bike to put together...
    Thanks so much and Merry Christmas.
    - Ricky

Posting Permissions

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