Show message on locked cells

  • Thread starter Thread starter Sean Bishop
  • Start date Start date
S

Sean Bishop

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
 
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:
 
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
 
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
 
Back
Top