Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Menu Item
Thanks again to everyone for their help. Works perfectly!
"Ron de Bruin" wrote: More ID information you can find here http://support.microsoft.com/default...66&Product=xlw XL97: List of ID Numbers for Built-In Command Bar Controls http://support.microsoft.com/default...14&Product=xlw XL97: Sample Macros to Return ID for a CommandBar Control http://support.microsoft.com/default...55&Product=xlw XL97: WE1183: "Customizing Menu Bars, Menus, and Menu Items" http://support.microsoft.com/default...19&Product=xlw XL97: Sample Macros for Customizing Menus and Submenus http://support.microsoft.com/default...78&Product=xlw XL97: Sample Macros That Customize and Control Shortcut Menus -- Regards Ron de Bruin http://www.rondebruin.nl "JE McGimpsey" wrote in message ... In article , "Bill" wrote: I've never used the ThisWorkbook code module - what is the purpose of that? http://www.mcgimpsey.com/excel/modules.html Also, if my company is using Excel 97, is it safe to assume the other users who will open this workbook will have the Unprotect Sheet... I of 893 also? In all current versions it is. I suppose that it's possible it will change, but given that it would break existing code, it's unlikely. You could check for Commandbars(1).Controls("Tools").Controls( _ "Protect").Controls("Unprotect Sheet...").Id but if the active sheet is not protected, it will fail (since the caption is changed to "Protect Sheet..."). It will also fail if the user has moved the control to another location. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) | |||
Adding a menu item right click menu when clicking on a single. | Excel Programming | |||
Disabling Right Click Menu | Excel Programming | |||
Disabling Menu Options | Excel Programming | |||
Disabling menu items in VBE | Excel Programming |