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
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