Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a VBA program that was written using Excel 2000 and recently we
have installed it on XP machines with Excel 2003. Everything works fine except I cannot prevent the user from clicking on the menu bar and getting the option to show built-in menu's My program creates its own Menu and toolbar and I don't want the user to be able to activate any other command bars. In Excel 2000 I used the code " Application.CommandBars("toolbar list").Enabled = False" and that worked great for Excel 2000 and previous versions but it does not work for Excel 2003. I searched Microsoft and Excel help and all I can find is how to prevent a toolbar from being changed. I believe that the above code is undocumented and I found it in this forum 3 or 4 years ago. Any help will be appreciated. Merlyn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel CommandBars | Excel Discussion (Misc queries) | |||
How to attach commandbars with VBA | Excel Programming | |||
CommandBars | Excel Programming | |||
Built in Commandbars | Excel Programming | |||
Built In CommandBars | Excel Programming |