Hiding macro code

  • Thread starter Thread starter Seamus McMillan
  • Start date Start date
S

Seamus McMillan

I'm sure there's a simple way to do this but I've not
been able to find it. I can hide/protect Excel
sheets/formulas, etc. but how do you prevent users
accessing the VB Editor and seeing your macro code? I
don't have digital signatures, etc and I want users to be
able to run the macros without hassle, just not visualize
the code.

Many thanks

Seamus McMillan
 
In the VB Editor:
Tools/VBAProject Properties/Protection/Lock for editing (and add password)

This is NOT secure, by the way. Crackers for these passwords are ten a
penny.

A more secure way would be to compile your code. That requires some
programming nouse and some compiler software such as developer version of
Office.
 
Back
Top