Protecting a VBA project

[Lynnette]

I need to password protect a VBA project. This is being done internally and the people with the password will be within the office. How do I do the protect. The worksheets will be password protected, but in order to perform sum of the operations the worksheets will be unprotected and then reprotected. We are trying to protect the password that will be in the documentation in the macro.

 

[Colin Legg]

Hi,

Open up the visual basic editor (Alt+F11) and make sure you have your project selected in the project explorer window.

Then go Tools | VBAProject Properties | Protection Tab
Tick the lock project for viewing checkbox
Enter in the password.

You'll only see the protection take effect once you have Saved + Closed + Reopened the file.


By the way, do the worksheets need to be unprotected to do this sum?

 

[Diablo II]

try this

ActiveSheet.Protect password:="anystring"

ActiveSheet.Unprotect password:="anystring"

 

[Lynnette]

Hi,

Open up the visual basic editor (Alt+F11) and make sure you have your project selected in the project explorer window.

Then go Tools | VBAProject Properties | Protection Tab
Tick the lock project for viewing checkbox
Enter in the password.

You'll only see the protection take effect once you have Saved + Closed + Reopened the file.


By the way, do the worksheets need to be unprotected to do this sum?

Yes, they do.

 

[Colin Legg]

If you say so, Lynette.

If you have any more questions or problems regarding protecting the VBA project then let us know.

 

[jcalhau]

Hi, I need to protect a VBA project programatically (ie with code). Anyone has any helpful sugestions?
The problem is that when I programatically copy the worksheets to a new workbook and save that workbook "as" the saved version's code contained in the worksheets is not protected even thought the original project is, allowing user to interfere with it.
Many thanks