View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JulieD JulieD is offline
external usenet poster
 
Posts: 618
Default VBA code protection in Excel

Hi

in the VBE Window, right mouse click on your project's name (the workbook
name) and choose VBAproject properties .. choose the protection tab, enter
the password in there to password protect it.

Cheers
julieD
"VBA code protection in Excel" <VBA code protection in
wrote in message
...
how can i protect VBA code embedded in Excel, when distribute it to users.
for example, if users click "ALT+F11" to display VBA edit window, and want
to
expand the code window, he need input one password, thanks