"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