ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   protect Micro (https://www.excelbanter.com/excel-programming/366000-protect-micro.html)

Ken

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

Norman Jones

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





All times are GMT +1. The time now is 09:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com