Can there be multiple passwords for one spreadsheet?
 

I would like to have a level of passwords for the spreadsheet our company
works. Some users should have access to the whole sheet and some users would
be limited to certain cells.
Is this posible?

Can there be multiple passwords for one spreadsheet?
 

Yes, a "Change-Event Macro" can be written that will hide or unhide specific
columns and or rows according to the text (username or whatever) entered in
a certain cell...........the details are specific to the actual application.

hth
Vaya con Dios,
Chuck, CABGx3



"Twin468" wrote:

I would like to have a level of passwords for the spreadsheet our company
works. Some users should have access to the whole sheet and some users would
be limited to certain cells.
Is this posible?

Can there be multiple passwords for one spreadsheet?
 

Thanks!

"CLR" wrote:

Yes, a "Change-Event Macro" can be written that will hide or unhide specific
columns and or rows according to the text (username or whatever) entered in
a certain cell...........the details are specific to the actual application.

hth
Vaya con Dios,
Chuck, CABGx3



"Twin468" wrote:

I would like to have a level of passwords for the spreadsheet our company
works. Some users should have access to the whole sheet and some users would
be limited to certain cells.
Is this posible?

Can there be multiple passwords for one spreadsheet?
 

Happy to help.............

Vaya con Dios,
Chuck, CABGx3



"Twin468" wrote:

Thanks!

"CLR" wrote:

Yes, a "Change-Event Macro" can be written that will hide or unhide specific
columns and or rows according to the text (username or whatever) entered in
a certain cell...........the details are specific to the actual application.

hth
Vaya con Dios,
Chuck, CABGx3



"Twin468" wrote:

I would like to have a level of passwords for the spreadsheet our company
works. Some users should have access to the whole sheet and some users would
be limited to certain cells.
Is this posible?

Can there be multiple passwords for one spreadsheet?
 

xl2002+ has this ability.

Tools|protection|allow users to edit ranges

Before xl2002, you could supply macros that only offer the user what you want
them to do.



Twin468 wrote:

I would like to have a level of passwords for the spreadsheet our company
works. Some users should have access to the whole sheet and some users would
be limited to certain cells.
Is this posible?

--

Dave Peterson