MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How Do I Prevent a Macro From Being Viewed or Edited?


Posted by ereit on November 04, 2000 9:42 PM

How do I lock up a macro so other users of my workbook cannot view or tamper with the macro?


Posted by Celia on November 04, 2000 10:40 PM


In the VB Editor go to Tools>VBAProject Properties>Protection

Celia

Posted by Ivan Moala on November 04, 2000 11:53 PM

In the VBA Editor
Select Tools / VBA Project properties
In the dialog box select the Protection Tab
Click > Lock project from View
Enter password

Don't forget it !!


Ivan

Posted by JAF on November 06, 2000 3:38 AM

WARNING

Whilst it is possible to protect your VBA code as detailed by Ivan and Celia, there is software available which can reveal the password used.

Don't use any password that you use elsewhere!

JAF