Able to access VB code on a protected workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KSP - 30 Jun 2005 14:24 GMT

I've password protected a workbook. It locks down the worksheets to limit
users access. I found, though, that users are easily able to get into the VB
code by either using the Tools drop down or the Alt+F11 keys.

Is there any way to secure the VB code?

Thanks

Reply to this Message

Roman - 30 Jun 2005 15:09 GMT

Right click the VB project in VB Editor and in VBAProject properties
set the protection.

Reply to this Message

purplemx - 26 Jan 2006 15:46 GMT

Hi try this
go to
Tools> then Macro > Visual Basic Editor >

Tools > VBA Projects Properties > Protection

Thats all, add the password you want it i hope this can help you.

Bye

Reply to this Message