View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Preventing users from changing macros

Use
Option Private Module
at the top of the module and they won't even see them.
Assign all to shapes/buttons
Password protect the code

Won't keep me out but will most.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JS101" wrote in message
...
How do I prevent users from changing macro code in a workbook? There are
lots of options for protecting cells, but I don't see anything for
preventing
a user from opening VBA and changing code.

Thanks.