Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Show Full Menus (Excel 2000)

    Hi Gang

    Is there a way to programmatically show all menu items in Excel 2000?

    Some of my users are complaining that they get confused when they don't see the full menu with all the commands in it, and some others like that feature because they know that they will get what they work with the most.

    So I have to programmatically, when the User logs on, disable and enable this feature. I looked under customize and I saw the checkbox, but when I recorded it, nothing was recorded. Is this option available for the developers to tinker with?

    MSKB article Q213398 shows only a manual solution, and it points out that this feature affects all of Office's components <img src=/S/doh.gif border=0 alt=doh width=15 height=15>... so it is dangerous to say the least.

    TIA

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  2. #2
    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: Show Full Menus (Excel 2000)

    Hi Wassim,
    It's a registry setting - on my system it's in HKCUSoftwareMicrosoftOffice9.0CommonToolbars
    The key is a DWORD called AdaptiveMenus. 0 is off and 1 is on.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Show Full Menus (Excel 2000)

    Thanks Rory

    I will look into it, and see if how far I get.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  4. #4
    New Lounger
    Join Date
    May 2001
    Location
    New York City, NY
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Show Full Menus (Excel 2000)

    To disable this feature, use this VBA command:

    CommandBars.AdaptiveMenus = False

    It applies to all of the CommandBars in the application, so you only need the single command.

  5. #5
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Show Full Menus (Excel 2000)

    Stan

    Surely that would be easier than hacking the registry. Thanks. I had found it by browsing the Object Browser and I used it and implemented the solution already. I test to see if the version is 2000 or later, then I test to see if the User has requested that the application display all menu items, and if so I capture the state of the menus first, change it to False for that session, and then at the end of the session return it back to the way it was.

    Thanks for your input.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

Posting Permissions

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