View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
MSweetG222 MSweetG222 is offline
external usenet poster
 
Posts: 158
Default Protect Macros From inadvertent Use

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