|
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 |
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 |
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 |
Show message on locked cells
I would simply make locked cells unselectable when protecting the sheet.
How do you think users will wreck the rest of the sheet trying to access non-selectable cells? Gord Dibben MS Excel MVP On Tue, 21 Apr 2009 05:44:02 -0700, Sean Bishop <Sean wrote: 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 |
| All times are GMT +1. The time now is 01:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com