Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I lock formulas, but still allow rows to be added or delet.
I can't find my previous question. I want to lock just the formulas. I
still want to be able to add or delete rows and be able to adjust row height. Any suggestions? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I lock formulas, but still allow rows to be added or delet.
Tools Protection Protect Sheet
Then, choose what you want the user to do or not do. Regards, Ryan-- -- RyGuy "ericaamousseau" wrote: I can't find my previous question. I want to lock just the formulas. I still want to be able to add or delete rows and be able to adjust row height. Any suggestions? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I lock formulas, but still allow rows to be added or delet.
I think this requires XL 2003
best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "ryguy7272" wrote in message ... Tools Protection Protect Sheet Then, choose what you want the user to do or not do. Regards, Ryan-- -- RyGuy "ericaamousseau" wrote: I can't find my previous question. I want to lock just the formulas. I still want to be able to add or delete rows and be able to adjust row height. Any suggestions? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I lock formulas, but still allow rows to be added or delet.
xl2002, actually.
Bernard Liengme wrote: I think this requires XL 2003 best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "ryguy7272" wrote in message ... Tools Protection Protect Sheet Then, choose what you want the user to do or not do. Regards, Ryan-- -- RyGuy "ericaamousseau" wrote: I can't find my previous question. I want to lock just the formulas. I still want to be able to add or delete rows and be able to adjust row height. Any suggestions? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Preserving hyperlinks when rows are added | Excel Discussion (Misc queries) | |||
lock column size for some rows and resize for other rows. | Excel Discussion (Misc queries) | |||
Identify New Added Rows | Excel Worksheet Functions | |||
Rows added after refresh not in formula | Excel Worksheet Functions | |||
Excel cell show sum upto 500 Exceede delet without if else conditi | Excel Worksheet Functions |