| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I lock a linked cell formula??
You only need to protect the other sheets, because that's where the formula is.
"lauraroebuck" 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! -- 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I lock a linked cell formula??
But they need to enter data on the other sheets. What happens is they can overwrite the data that has copied across if it has changed. It has conditional formatting so that any changes are hightlighted as red So thanks for your reply but this does not help me  -- 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I lock a linked cell formula??
So just lock the cells you need. and leave the other editable
"lauraroebuck" wrote: But they need to enter data on the other sheets. What happens is they can overwrite the data that has copied across if it has changed. It has conditional formatting so that any changes are hightlighted as red So thanks for your reply but this does not help me -- 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I lock a linked cell formula??
I can't as it is the same cells that they need to enter data into -- 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I lock a linked cell formula??
You can't have it both ways. If you want it to be formula then they're not
suuposed to fill in information into those cells. They are supposed to be calculated with every change in the varinats in the formula "lauraroebuck" wrote: I can't as it is the same cells that they need to enter data into -- 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I lock a linked cell formula??
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 |
| Reply |
| 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 | |||
Hybrid Mode
