View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Phil Hageman Phil Hageman is offline
external usenet poster
 
Posts: 80
Default 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



.