lauraroebuck;334998 Wrote:
I am creating a template for a workbook of forms. Each sheet links to
the previous one. (ie once they enter data to the first sheet it copies
across to all sheets so they don't have to re-enter the data every
time). I have done this by linking the cells.

However I want to protect the link formula so that if they enter data
then delete it they only delete the data not the link formula. Is this
possible...please help!
Welcome to the board!, perhaps, do this on your other sheets: press
Ctrl+A (all cells selected), right click in selection, choose format
cells, Protection tab uncheck locked click ok, select A1 repeat the same
but check locked and hidden then protect the worksheet, now the whole
sheet will be editable but the formula protected!


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93655