![]() |
Locking a project
Hi,
In VB project protection using right click "VBAproject Properties" the password tab has :- a) Lock project for viewing b) Password to view project properties. If I dont check a) then the user who is able to view the code is able to modify the code. Why?.Is this not something analogous to Worksheet protection in 2002 where u can let somebody view data but may not give them the authority to modify it. Can a project be locked for editing but still can be viewed? What does b) mean Regards, Hari India |
Locking a project
Hari,
The object is to keep others from viewing your code. So check Lock. Then enter a password (twice). The next time you open the Workbook and go to VBA you will be required to enter your password before you can view the code. Regards, Jim Kobzeff "Hari" wrote in message ... Hi, In VB project protection using right click "VBAproject Properties" the password tab has :- a) Lock project for viewing b) Password to view project properties. If I dont check a) then the user who is able to view the code is able to modify the code. Why?.Is this not something analogous to Worksheet protection in 2002 where u can let somebody view data but may not give them the authority to modify it. Can a project be locked for editing but still can be viewed? What does b) mean Regards, Hari India |
Locking a project
Hi Jim,
My doubt is can we give a third person right to view the code but not the right to modify the code. Is it possible to specify a read only setting for the code. Regards, Hari India "JK" wrote in message news:6usXc.5857$2F.2009@trnddc05... Hari, The object is to keep others from viewing your code. So check Lock. Then enter a password (twice). The next time you open the Workbook and go to VBA you will be required to enter your password before you can view the code. Regards, Jim Kobzeff "Hari" wrote in message ... Hi, In VB project protection using right click "VBAproject Properties" the password tab has :- a) Lock project for viewing b) Password to view project properties. If I dont check a) then the user who is able to view the code is able to modify the code. Why?.Is this not something analogous to Worksheet protection in 2002 where u can let somebody view data but may not give them the authority to modify it. Can a project be locked for editing but still can be viewed? What does b) mean Regards, Hari India |
All times are GMT +1. The time now is 03:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com