Disable macro selections under tools menu
 

I have macros to automate on a sheet and want to disable the option to run a
macro under the tool selection on the menu bar. How would I do this?


Thank you

Disable macro selections under tools menu
 

Change the macro's declaration from public to private. If you want to hide
all of the procedures in a specific module then use
Option Private Module
at the top of the code module.
--
HTH...

Jim Thomlinson


"Jeremy" wrote:

I have macros to automate on a sheet and want to disable the option to run a
macro under the tool selection on the menu bar. How would I do this?


Thank you