ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Protecting my project (https://www.excelbanter.com/excel-programming/350690-protecting-my-project.html)

Brian Matlack[_48_]

Protecting my project
 

Hi!
I want to protect my VBA project so that anyone using the workbook
cannot see or change the code. When I'm in VBA and I go to Tools l
VBAProject Properties and I enter a password on the Protection tab it
does not seem to "Lock" it.
I know I'm just missing something. Please help!
Thanks!


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=502200


rmullen

Protecting my project
 
Try restarting the application (ie - close it and then open it back up)


Brian Matlack[_49_]

Protecting my project
 

That was it!!
I was expecting it to work the same way as the worksheet protection.
Thanks for the help!


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=502200



All times are GMT +1. The time now is 05:06 AM.

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