Disable macro selections under tools menu

[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

 

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