Disable macro selections under tools menu

  • Thread starter Thread starter Jeremy
  • Start date Start date
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
 
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.
 
Back
Top