Hiding macro code

[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

 

[Jack Schitt]

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.

 

[zz5151353]

That's Good , I am waiting for this good news, I want to know tha
answer

 

[zz5151353]

Oh, I see Jack Schitt Thanks yo