ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Office 2007 Shortcut menus don't stay on (https://www.excelbanter.com/excel-programming/425931-office-2007-shortcut-menus-dont-stay.html)

XP

Office 2007 Shortcut menus don't stay on
 
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.


All times are GMT +1. The time now is 11:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com