Running macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to prevent running a macro through the Tools menu choice?
Thanks!
 
Sub MyMacro(optional dummy = 1)

or

Private Sub MyMacro()

The macro can still be run through the tools menu choice, but won't be
listed.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
prevent user from deleting a tab prevent running macro from menu 5
Keyboard shortcuts 3
Don't re-run macro for five seconds...? 8
Cannot display Add-in Macro list without going to VBA/Project 5
Macro fails from Tools menu, works when step through in VBA. 1
Simple Macro 1
Excel Add-In 7

Back
Top