Protecting code in module
 

I have some code in a workbook module - is there a way to
limit access/edit in the module? Dealing with curious
users...

Thanks,
Phil

Protecting code in module
 

Thanks, Paul. What you've given me is many nights of
quiet rest...
-----Original Message-----
Phil, To protect the VBA project press alt and F11 to
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

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can
benefit from it
** remove news from my email address to reply by email **
"Phil Hageman" wrote in message
...
I have some code in a workbook module - is there a way
to
limit access/edit in the module? Dealing with curious
users...

Thanks,
Phil


.