How To Hide Code?

  • Thread starter Thread starter Alan Greenwood
  • Start date Start date
A

Alan Greenwood

I use Excel 97 on Windows NT and 2000. I thought that protecting the
sheet would also hide the code but it doesn't. I can't seem to find
anything in the help file about this - can anyone offer advice? Thanks
a lot in advance.
----------------------------------------------------
Do NOT reply to the email address in the headers. It
is an address used solely for trapping spam and its
contents are never checked. If you want to reply to
this message, please post to the newsgroup.
----------------------------------------------------
 
Alan,

In the VBA Editor, go to the Tools menu, choose VBA Project Properties, then
the Protection tab. There, put a check next to "Lock project for viewing"
and enter a password.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Alan,

In the VBA Editor, go to the Tools menu, choose VBA Project Properties, then
the Protection tab. There, put a check next to "Lock project for viewing"
and enter a password.
Click to expand...

Also read the current thread "How can I protect my work?"
--
auric "underscore" "underscore" "at" hotmail "dot" com
*****
- That doesn't make any sense.
- Barry, this is exactly the kind of desperate grip on rationality that
keeps you from getting promoted every year.
 
Back
Top