Don't Allow User to Run Macros Manually, but keep Macros Activated

[ldaniels21]

Hi all,

First post, so please forgive any formatting problems.

I have the VBA protected, so that no editing can be done to the code, nor can the code be viewed by the user. However, I also don't want the user to be able to run macros by manually accessing them in the Programmer tab, all the while keeping these macros active to automatically run based on certain user actions.

I have tried manually password protected various macros (which then prompt for password in InputBox etc.) but it is a very large file (20 modules, 50-60 procedures) and this can be very tedious, as well as cause for problems when calling one protected procedure within other Procedures and modules. Any suggestions for how to combat this issue?

Thanks!

 

[RoryA]

If you add

Option Private Module

to the top of your modules, the routines will not appear in the macros dialog, although the user could theoretically manually type the name of a routine into the dialog and run it.

 

[ldaniels21]

Works great! Thanks for the quick reply Rory, that should be fine to prevent access with the average level of user we have.