Lock down certain cells and prompt if used

[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

 

[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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.



.