Preventing users from changing macros
Another way would be to add something like this
Sub MyProcedure(Optional myString as string)
It doesn't require the user to enter the string, but it's not displayed in
the list of Subs upon pressing ALT F8. Of course, they still could go to
the VBE and edit it there.
We've added a corporate digital signature to our assets. It won't prevent
changes, but it does make it easier for users to open workbooks with macros
and they are already enabled (once the signature is recognized on their
system).
--
HTH,
Barb Reinhardt
If this post was helpful to you, please click YES below.
"JS101" wrote:
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.
|