Locking a project

  • Thread starter Thread starter Hari
  • Start date Start date
H

Hari

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,

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Locking the VBA Project 13
Macro to lock project from viewing 1
"Lock project for viewing" doesn't get saved 1
Cannot view code in VBE of a file with no password protection 3
protect VBA project view by VB code 1
Project Locking Woes 1
unlocking VBA project programatically 1
Programmatically modifying code using VBE in a protected project 4

Back
Top