Hide Macro

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?

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" <astrikor.23znwb_1141212902.1284@excelforum-nospam.com> wrote in
message news:astrikor.23znwb_1141212902.1284@excelforum-nospam.com...
>
> 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
>

Protect the VBA project,

To protect the VBA project, from your workbook right-click the workbook's
icon and pick View Code. This icon is to the left of the "File" menu this
will open the VBA editor, in Project Explorer right click on your workbook
name, if you don't see it press CTRL + r to open the Project Explorer then
select VBA project properties, protection, check lock project for viewing
and set a password. Press Alt and Q to close this window and go back to your
workbook and save and close the file. Be aware that this password can be
broken by third party software

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"astrikor" <astrikor.23znwb_1141212902.1284@excelforum-nospam.com> wrote in
message news:astrikor.23znwb_1141212902.1284@excelforum-nospam.com...
>
> 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
>