How To Hide Code?

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.
----------------------------------------------------
 
C

Chip Pearson

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
 
A

Auric__

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top