ExcelBanter - Running macros

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Running macros (https://www.excelbanter.com/excel-programming/313673-running-macros.html)

cottage6

Running macros

Is there a way to prevent running a macro through the Tools menu choice?
Thanks!

Tom Ogilvy

Running macros

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.

--
Regards,
Tom Ogilvy

"cottage6" wrote in message
...
Is there a way to prevent running a macro through the Tools menu choice?
Thanks!

All times are GMT +1. The time now is 02:59 PM.