Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn off menu options with vba
Hi
Can anyone advise me if it is possible and also how to do it if it is, to turn off menu options with VBA code. I ask this as i have disable the VB toolbar on a sheet to protect my code, but it can still be accessed via menu options. I dont really want to password protect the code as other people may need to use it as and when, but these people will know how to get the code options back. Can anyone help Nath. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn off menu options with vba
You can turn them off by disabling them like so:
CommandBars(1).Controls("Tools").Controls("&Option s").Enabled = False The ampersand is for the shortcut key - it seems to be pretty picky about having that in there. Hope that helps! Leah "nath" wrote in message ... Hi Can anyone advise me if it is possible and also how to do it if it is, to turn off menu options with VBA code. I ask this as i have disable the VB toolbar on a sheet to protect my code, but it can still be accessed via menu options. I dont really want to password protect the code as other people may need to use it as and when, but these people will know how to get the code options back. Can anyone help Nath. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you turn off the Autofill Options box when dragging cells. | Excel Discussion (Misc queries) | |||
How can i turn off the auto fill options button? | Excel Discussion (Misc queries) | |||
How can I turn back on my sort options in excel 2007? | Excel Worksheet Functions | |||
turn off auto fill options box Excel 2003 | Excel Discussion (Misc queries) | |||
Turn off Reviewing options at the application level | Excel Discussion (Misc queries) |