Can there be multiple passwords for one spreadsheet?

T

Twin468

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

CLR

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
 
T

Twin468

Thanks!

CLR said:
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
Click to expand...
 
D

Dave Peterson

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