| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Restricting entry | Excel Worksheet Functions | |||
| restricting use of certain characters | Excel Discussion (Misc queries) | |||
| Restricting Rows | Excel Discussion (Misc queries) | |||
| Restricting VBA macros | Excel Programming | |||
| Restricting cells | Excel Programming | |||
Linear Mode
