Lock down certain cells and prompt if used

T

Thrava

Hi Group,

How do I prompt users that some particular cells are not
editable (are locked) if the user tries to overwrite them?
Thanks
 
N

Norman Harker

Hi Thrava!

If you have left the lock on the cells and if you have protected the
sheet, you don't need to. Excel will give the message that you can't
alter the cell.

I tend to highlight unlocked cells at the time that I remove the lock.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
T

thrava

Got it.
Thank you
-----Original Message-----
Hi Thrava!

If you have left the lock on the cells and if you have protected the
sheet, you don't need to. Excel will give the message that you can't
alter the cell.

I tend to highlight unlocked cells at the time that I remove the lock.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.



.
Click to expand...
 
Top