View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
bpeltzer bpeltzer is offline
external usenet poster
 
Posts: 180
Default Security for VBA codes

From the VB Editor, go to Tools VBA Project Properties and select the
Protection tab. There you have the option to set a password for the project.

"excelnut1954" wrote:

I haven't notice any on this subject. So...
Is there a way to PW protect the VBA screen? Also, assuming there is,
can it be set up to allow others to edit (and save) the spreadsheet
only? I poked around the pull down menus, but couldn't see an
explaination. It must be so simple that I just didn't see it.
As always..... I would appreciate any help.
excelnut