ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Locking a project (https://www.excelbanter.com/excel-programming/308117-locking-project.html)

Hari[_3_]

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



JK

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





Hari[_3_]

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