| 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 | |||
Hybrid Mode
