ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Protecting Macro's (https://www.excelbanter.com/excel-programming/274964-re-protecting-macros.html)

Rocky McKinley

Protecting Macro's
 
Hi Kathy,

In the visual basic editor (Alt + F11)
From the menus select "Tools/VbaProject Properties
Select "Protection" at top
Select "Lock Project for Viewing" check box
Enter a password twice and click "Okay"
Save the workbook and next time you open it the Vba is protected.

Regards, Rocky McKinley


"Kathy Goldie" wrote in message
...
Can you protect a macro so a user can not change or
delete it





All times are GMT +1. The time now is 02:11 PM.

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