Thread: protect Micro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default protect Micro

Hi Ken,

In the VBE,

Tools | VBAProperties | Protection | Lock Project For Viewing |
Insert password | OK

Now, save, close and re-open the file.

Note, however, that Excel security is very weak and may readily be
surmounted,



---
Regards,
Norman


"Ken" wrote in message
...
I won't to protect a macro so it can't be changed.
thank