PDA

View Full Version : Disable menu options



ukphoenix
09-25-2007, 04:01 AM
Hi all,
I have a macro that is attached to a workbook. So far the main sheet is only available if macros are enabled otherwise it remains hidden.
Also within this macro I have disabled the cut, copy, paste option from the drop downs but have noticed there is other options that will allow access. I need to also shade out (disable) the Tools > Macro button on the toolbar but cannot find the required function.
Heres a snippitt of what i have.....

Call EnableMenuItem(21, Allow) ' cut
Call EnableMenuItem(19, Allow) ' copy
Call EnableMenuItem(22, Allow) ' paste
Call EnableMenuItem(755, Allow) ' pastespecial

And heres what I need but cannot find the right command

Call EnableMenuItem(???, Allow) ' macro

Does anyone have a link where a list of Allow parameters/numbers for keypress

Bob Phillips
09-25-2007, 04:04 AM
application.commandbars("Worksheet Menu Bar").controls("Tools").Controls("Macro").enabled=false

ukphoenix
09-25-2007, 04:22 AM
Thanx mate...i knew i was overlooking something didnt even enter my head to use 'application' ............d'oh:oops: