Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: Some Sub-Menus Disabled. Greyed Out

  1. #1
    Join Date
    6th November 2006
    Posts
    3

    Some Sub-Menus Disabled. Greyed Out

    Hi
    I have noticed that the submenus for the following main menu items are disabled

    Edit Insert Format Data

    The submenus for the other main menu items are fine.

    I have not run any macros that alter the menus.

    I have tried Tools>Customise Reset Menu and Toolbar usage. I then exit the Excel session, but the problem still remains,

    Does any one have any ideas?

    Thank you

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    9th September 2006
    Location
    Cheshire-UK
    Posts
    457

    Re: Some Submenus Disabled

    Try this in a standard sub:

    VB:
    Sub MenuBar_Restore() 
        CommandBars("Worksheet menu bar").Reset 
    End Sub 
    
    
    it should reset the worksheet menu bar back to normal!

    Regards,
    Simon

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,718

    Re: Some Submenus Disabled

    Is your Worksheet Or Workbook Protected? Tools>Protection.

    When you Reset Toolbars in Excel you must ensure you have the correct Toolbar (Worksheet Menu Bar in your case) checked AND highliighted before clicking Reset.

    Also try, Help>Detect & Repair

  4. #4
    Join Date
    6th November 2006
    Posts
    3

    Re: Some Sub-Menus Disabled. Greyed Out

    Hi guys
    Thanks for the advice.

    The macro worked perfectly.
    Thanks Simon

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    29th June 2012
    Posts
    1

    Re: Some Submenus Disabled

    Quote Originally Posted by Simon Lloyd View Post
    Try this in a standard sub:

    VB:
    Sub MenuBar_Restore() 
        CommandBars("Worksheet menu bar").Reset 
    End Sub 
    
    
    it should reset the worksheet menu bar back to normal!

    Regards,
    Simon


    where do i enter the vb script?

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,068

    Re: Some Submenus Disabled

    Quote Originally Posted by kupii925 View Post
    where do i enter the vb script?
    In a normal module in the VBEditor (Insert > Module).
    Execute that procedure.
    Regards,

    Wigi

    Excel MVP 2011-2014



    For more Excel memes: visit http://www.wimgielis.be ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Macro Code To Create Custom Menus & Sub Menus
    By MJB123 in forum EXCEL HELP
    Replies: 4
    Last Post: June 9th, 2008, 22:10
  2. Sheet Insert Disabled/Greyed Out
    By ADEL in forum EXCEL HELP
    Replies: 1
    Last Post: March 16th, 2008, 12:51
  3. Create Toolbar Menus & Sub Menus
    By gowri_j23 in forum EXCEL HELP
    Replies: 3
    Last Post: October 5th, 2007, 09:54
  4. Macro Run Greyed Out Except In Vbe
    By abcfo in forum EXCEL HELP
    Replies: 3
    Last Post: February 8th, 2007, 05:13

Bookmarks

Posting Permissions

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