modules
 

Is it possible to protect/lock individual modules rather
than the whole project?

modules
 

Libby,

No, protection applies to the entire project.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"libby" wrote in message
...
Is it possible to protect/lock individual modules rather
than the whole project?

modules
 

Chip,
When you press alt+F11 and click on the project explorer,
if the project is locked you will be prompted for a
password.

However, I would like to be able to just prevent one
module from being accessed.

-----Original Message-----
Libby,

No, protection applies to the entire project.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"libby" wrote in
message
...
Is it possible to protect/lock individual modules rather
than the whole project?


.

modules
 

Libby,

You can't protect only a single module. The password protection applies to
the entire workbook project, and once a correct password is supplied, all
components of the project are accessible. You can't do what you want to do.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"libby" wrote in message
...
Chip,
When you press alt+F11 and click on the project explorer,
if the project is locked you will be prompted for a
password.

However, I would like to be able to just prevent one
module from being accessed.

-----Original Message-----
Libby,

No, protection applies to the entire project.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"libby" wrote in
message
...
Is it possible to protect/lock individual modules rather
than the whole project?


.

modules
 

ok thanks Chip

-----Original Message-----
Libby,

You can't protect only a single module. The password
protection applies to
the entire workbook project, and once a correct password
is supplied, all
components of the project are accessible. You can't do
what you want to do.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"libby" wrote in
message
...
Chip,
When you press alt+F11 and click on the project
explorer,
if the project is locked you will be prompted for a
password.

However, I would like to be able to just prevent one
module from being accessed.

-----Original Message-----
Libby,

No, protection applies to the entire project.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"libby" wrote in
message
...
Is it possible to protect/lock individual modules
rather
than the whole project?


.



.