Hide Macros from Users
Larry,
From the VBA Editor
Tools/VBA Project Properties
Protection tab
Check "Lock project for viewing"
Type is password
Note: There are plenty of ways to crack this password.
If you're trying to hide your code from an experienced
user (or one who might search for ways to do so within
these ng's or the Google archives), it's an exercise in
futility.
John
Larry Graff wrote:
I have an application in Excel that contains several
macros for an end user. I don't want the user to be able
to modify or see the macro code. Can someone tell me how I
can hide the macros from being viewed and modified?
Thanks In Advance.
Larry Graff
|