Locking cells

justin_n84

Board Regular
Joined
Jan 29, 2017
Messages
51
Hi,

I have a spreadsheet with some formulas in to represent a receipt.

I want to be able to lock the cells with formulas. I think this is easy enough.

My trouble is I want to lock some cells to accounting GBP currency. basically so a figure can be entered but so that somebody cannot delete this form. Can this be done. When ever I lock it I can't seem to change anything.

I'm just worried when somebody uses it to enter a figure if using an old receipt as a template they may delete the cell to put a new figure in. Problem is it then deletes the accounting format.....

Any help is much appreciated.
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

justin_n84

Board Regular
Joined
Jan 29, 2017
Messages
51
The validation function doesn't allow you to stop people from clicking in the cell and hitting delete (and it deleting the accounting format).... Not unless I'm missing something?
 

Watch MrExcel Video

Forum statistics

Threads
1,089,755
Messages
5,410,238
Members
403,304
Latest member
shabsbingo

This Week's Hot Topics

Top