Remove the VBA from being edited by anyone else

[felipedferreira11]

Hello everyone, does anyone know if there is a way in excel 2007 that I can remove the ability of users to get into the VBA module? I would like to create a macros and be the only one to enter in the VBA for that specific workbook. no other users should be able to input new modules to my workbook. this would have to be done within excel, no group policy.

 

[Norie]

Goto Tools>VBAProject Properties, select the Protection tab, click "Lock project from viewing" and enter a password.

 

[Michael M]

AND
Don't forget the password !!!!!.....

 

[jolivanes]

Keep the code in your personal workbook.