Warning promt prior to overtyping data

colmcg

Board Regular
Joined
Jul 2, 2004
Messages
101
Is there a way of alerting a user that they are about to type into a cell already containing data.

I have a protected spreadsheet with unlocked cells. I have applied validation to the unlocked cells to limit the input to a specific range. Once data has been entered into the unlocked cells it shouldn't need to be altered unless a wrong figure has been entered.

I don't want to 'prevent' them from overtyping the data but warn them they are 'about to' overtype data.

Is this at all possible?
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Watch MrExcel Video

Forum statistics

Threads
1,118,318
Messages
5,571,527
Members
412,401
Latest member
allenayres83
Top