Macros in menu

[Sam]

I have a userform with command buttons that initiate procedures in general
modules. How can I prevent these procedures from being run via the
Tools...Macro...Macros menu?

 

[PCLIVE]

Place your module code into the button code.
Copy the general module code, right-click on the userform button and select
'View code'. Paste code here. The remove the general module code.
Backup file first.

HTH,
Paul

 

[Jim Rech]

Putting Option Private Module at the top of each standard module should do
it.

 

[Sam]

Excellent! Thank you so much! It worked beautifully!