Restricting Macros

[Guest]

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.

 

[Fredrik Wahlgren]

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.

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

 

[Bob Phillips]

Add this to the module at the start

Option Private Module

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

This fixed the problem; thank you.

Add this to the module at the start

Option Private Module

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

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