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