Thread
:
Preventing users from changing macros
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett