Disable macro selections under tools menu

J

Jeremy

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
 
J

Jim Thomlinson

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