Results 1 to 3 of 3

Thread: Reset menus to standard

  1. #1
    Acolyte misi01's Avatar
    Join Date
    Jul 2011
    Location
    Stockholm,Sweden
    Posts
    31
    Articles
    0

    Reset menus to standard



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Somehow or other, I've managed to muck up one of my workbooks. When I open it, most of the options on the various menus are disabled.
    I've included a screen capture to show what I mean.

    I've been experimenting with enabling/disabling various menu options - maybe I've screwed up something there using this code I found somewhere
    Code:
    Application.CommandBars("Worksheet Menu Bar").FindControl(ID:=178, Recursive:=True).Enabled = False
    so I've tried running the following (variations) instead
    Code:
    Private Sub commandbars_reset1()
       'Application.CommandBars("Worksheet Menu Bar").FindControl(ID:=178, Recursive:=True).Enabled = True
       Application.CommandBars("Worksheet Menu Bar").Reset
       MsgBox "All reset (I hope)"
    End Sub
    Note that the options under the menus are not disabled for other workbooks, only this one. I can post the UI code if required, but this only contains a customized extra button on the home tab. I've also looked in the VBA code for any sort of disable code but I can't see anything.
    It's almost as if the workbook has got "stuck" with the settings that I saved it with at some time.
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	2012-03-17 10-07-01.jpg 
Views:	18 
Size:	14.1 KB 
ID:	500  

  2. #2
    Acolyte Andy Pope's Avatar
    Join Date
    Mar 2011
    Location
    London, England
    Posts
    41
    Articles
    0
    Excel Version
    2016
    That screen shot would strongly suggest the worksheet is protected. Check the Review tab for sheet protection.
    Cheers
    Andy

    www.andypope.info

  3. #3
    Acolyte misi01's Avatar
    Join Date
    Jul 2011
    Location
    Stockholm,Sweden
    Posts
    31
    Articles
    0

    B*gg**ation

    So simple !!!!!

    Exactly what it was - tons of thanks Andy

    (Michael, go into the corner and put your dunce's cap on)

Posting Permissions

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