PDA

View Full Version : Solved: How to protect your VBA codes?



genracela
04-28-2010, 06:46 PM
ALT F11 always opens the VBA editor and you can see the VBA codes.

What if I don't want other users to see and change it?

austenr
04-28-2010, 07:21 PM
To protect your code, open the Excel Workbook and go to Tools>Macro>Visual Basic Editor (Alt+F11). Now, from within the VBE go to Tools>VBAProject Properties and then click the Protection page tab and then check "Lock project from viewing" and then enter your password and again to confirm it. After doing this you must save, close & reopen the Workbook for the protection to take effect.

genracela
04-28-2010, 07:25 PM
thanks!!!