Restricting Macros
 

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

Restricting Macros
 

"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

Restricting Macros
 

Add this to the module at the start

Option Private Module

--

HTH

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


"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

Restricting Macros
 

This fixed the problem; thank you.

"Bob Phillips" wrote:

Add this to the module at the start

Option Private Module

--

HTH

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


"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

Restricting Macros
 

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