ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Able to access VB code on a protected workbook (https://www.excelbanter.com/excel-programming/333280-able-access-vbulletin-code-protected-workbook.html)

KSP[_2_]

Able to access VB code on a protected workbook
 
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

Roman[_4_]

Able to access VB code on a protected workbook
 
Right click the VB project in VB Editor and in VBAProject properties
set the protection.



All times are GMT +1. The time now is 02:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com