protect Micro

I won't to protect a macro so it can't be changed.
thank

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" <Ken@discussions.microsoft.com> wrote in message
news:C51D4200-BD7C-485D-BDEB-9F2CDBC8B308@microsoft.com...
>I won't to protect a macro so it can't be changed.
> thank