Protect Macros From inadvertent Use
At the top of the module where the code resides add
Option Private Module
This will keep all of the sub procedures and functions in the module private
so that they do not show up in the macro list...
--
HTH...
Jim Thomlinson
"MSweetG222" wrote:
Is it possible to save the worksheets to a different workbook that does not
contain your code? That way they never even have access to it.
--
Thx
MSweetG222
"Dean" wrote:
I password protected my macros so no one can edit them but, occasionally, I
want to send the file somewhere and I don't want them to be able to even run
the macros, particularly one that takes off all the password protection!
What is the easiest way to ensure they won't be able to run macros, short of
deleting all of them?
Thanks!
Dean
|