Hi Astrikor.

In the VBE (Alt-F11), with the project of interest selected:
Tools | VBA Project Properties | Protection
Lock and supply a password (Do not forget p/word!!)
Save, close and reopen file.


---
Regards,
Norman



"astrikor" wrote in
message ...

I need to find some way of inhibiting access to macro code. I have an
autorun macro which needs to be able to run but which must not be
viewed or edited without a password.
"Private Sub test()" does hide the macro, but the code can still easily
be accessed by hitting "Esc" while it is running. Does anyone know how
to introduce a password to enable access to code?


--
astrikor
------------------------------------------------------------------------
astrikor's Profile:
http://www.excelforum.com/member.php...o&userid=31465
View this thread: http://www.excelforum.com/showthread...hreadid=517746