Is it possible to Hide macros

[Ken Soenen]

Is it possible to HIDE your macros and VBA work from the user? If not, is it
possible to PROTECT them from change. Tried Protect Workbook but that didn't
work.

ken

 

[Paul B]

Ken, put private in front of you sub and you want see it when you press F8,
you can also 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 the left hand window right click on your
workbook name and 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

 

[Gord Dibben]

Ken

Following Paul's method of getting the the VB Editor may leave you in a
Thisworkbook module with no left-hand window.

Press CTRL + r to open the Project Explorer then carry on with Paul's
instructions.


Gord Dibben Excel MVP

 

[Ken Soenen]

Tried the suggestions by Paul and Gord. Protecting the VBA project is just
what I'm looking for. Thanks for your help. I spent many hours searching
thru the "help" files with only tired eyeballs to show for it.

ken