Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I lock a linked cell formula??
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! -- lauraroebuck ------------------------------------------------------------------------ lauraroebuck's Profile: http://www.thecodecage.com/forumz/member.php?userid=289 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93655 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FORMULA/FUNCTION TO LOCK AND UNLOCK A CELL | Excel Discussion (Misc queries) | |||
formula to lock cell? | Excel Discussion (Misc queries) | |||
I want to copy a formula down several rows and lock a cell ref. | Excel Discussion (Misc queries) | |||
In creating a spreadsheet how can I lock a formula cell only? | New Users to Excel | |||
How do I lock a formula in a cell in an Excel worksheet? | Excel Worksheet Functions |