I needed to use Option Private Module. But your reply introduced another
method to me; thank you.

"Fredrik Wahlgren" wrote:


"Ed" wrote in message
...
I have a program that uses VBA modules and macros. I've password
protected
the VBA. How do I restrict the running of the macros from the Tools,
Macros
menu? Edit and Delete are restricted but not Run. Thank you.
--
Ed

Have you tried the Application.Caller method? It should tell you how the
macro was called. I guess it should be possible to figure out whether it was
was called from the Tools|Macros menu item.

/Fredrik