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 Greenwood" wrote in message
...
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.
----------------------------------------------------

On Thu, 20 Nov 2003 12:55:10 -0600, Chip Pearson wrote:

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.

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.