Office 2007 Shortcut menus don't stay on

X

XP

Working in Office 2007 with Windows XP;

I have a program that can be used to enable and disable the shortcut menus
in Excel as follows:

Private Function ShortCutMenusEnable(argTrueToEnable As Boolean)
'true to enable all right-click/shortcut menus; false to disable:
Dim cbCommandbar As CommandBar
For Each cbCommandbar In Application.CommandBars
cbCommandbar.Enabled = argTrueToEnable
Next
End Function

This function works, BUT when the shortcuts are turned back on, the settings
don't stay. The next time I open a new workbook, the shortcuts are disabled
and I have to run my program again!

There must be a switch or something else I'm missing in 2007? Could someone
please clue me in?

Thanks for your assistance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Office 2007 Shortcut Menus 1
VBA for Dependents shortcut menu 0
Adding custom menus to existing excel application 0
Stuck on Office 2003 Menus, Task Bars, etc. 1
Shortcut menus in 2007 2
Checking if a font is installed (2007) 3
Customizing Shortcut Menus 0
Submenus on Shortcut Menus 2

Top