Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Show message on locked cells
I am using Excel 2003.
I have a spreadsheet in which two columns are locked and password protected. What I would like to do is display a message whenever anybody trys to access these cells. What I want is very much like a Comment (it would appear when the cursor moves over the cell) but if used it would mean copying the Comment to every protected cell. Is there a more space efficent solution? While this may seem overkill, as they cannot access the cells, unless there is a message to tell them to keep away the users are liable to wreck the rest of the spreadsheet trying to get into the protected cells. Many thanks in advance for your help. Sean |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Show message on locked cells
I used to color (e.g. to red) protected cells to inform users that they have
no matter with these cells. Regards, Stefi €˛Sean Bishop€¯ ezt Ć*rta: I am using Excel 2003. I have a spreadsheet in which two columns are locked and password protected. What I would like to do is display a message whenever anybody trys to access these cells. What I want is very much like a Comment (it would appear when the cursor moves over the cell) but if used it would mean copying the Comment to every protected cell. Is there a more space efficent solution? While this may seem overkill, as they cannot access the cells, unless there is a message to tell them to keep away the users are liable to wreck the rest of the spreadsheet trying to get into the protected cells. Many thanks in advance for your help. Sean |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Show message on locked cells
Hi, have you thought about data validation input messages? It doesn't work if
you hover, but you get the message once you select a cell. You can create an input message for an entire range of cells... grts, Ivo "Stefi" wrote: I used to color (e.g. to red) protected cells to inform users that they have no matter with these cells. Regards, Stefi €˛Sean Bishop€¯ ezt Ć*rta: I am using Excel 2003. I have a spreadsheet in which two columns are locked and password protected. What I would like to do is display a message whenever anybody trys to access these cells. What I want is very much like a Comment (it would appear when the cursor moves over the cell) but if used it would mean copying the Comment to every protected cell. Is there a more space efficent solution? While this may seem overkill, as they cannot access the cells, unless there is a message to tell them to keep away the users are liable to wreck the rest of the spreadsheet trying to get into the protected cells. Many thanks in advance for your help. Sean |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Message: Locked for editing... | Excel Discussion (Misc queries) | |||
Show Locked Cells | Excel Discussion (Misc queries) | |||
Locked cells show up in Apple Works | Excel Discussion (Misc queries) | |||
locked for editing message | Excel Discussion (Misc queries) | |||
show locked cells | Excel Discussion (Misc queries) |