View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dean[_8_] Dean[_8_] is offline
external usenet poster
 
Posts: 407
Default Protect Macros From inadvertent Use

That sounds too risky. If there is no other option, I suppose I could just
manually delete all the macros.

"MSweetG222" wrote in message
...
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