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?

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

"Sam" wrote in message
...
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?

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

--
Jim
"Sam" wrote in message
...
|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?

Excellent! Thank you so much! It worked beautifully!

"Jim Rech" wrote:

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

--
Jim
"Sam" wrote in message
...
|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?