Show Full Menus (Excel 2000)

Topic

New Reply

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 … so it is dangerous to say the least.

TIA

Wassim

Reply | Quote

Replies

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.

Reply | Quote

Thanks Rory

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

Wassim

Reply | Quote

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.

Reply | Quote

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

Reply | Quote