Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert row with a locked cell
I have a spreadsheet with multiple columns of data. Some of the columns
contain data that I want a user to be able to enter data in. There are other columns that are formulas that derive a value based on the user entered data in the other columns in that row. I want to protect the formula columns so I have them locked. All other modifiable columns I've unlocked. The problem is that once I set the protection accordingly I am unable to insert a row even if I've checked the Insert Row allowable function when setting the protection. Is it possible to insert a row that has a locked cell in the row with protection set? -- Robert |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert row with a locked cell
Yes it is possible.
Select the row header and Insert. Gord Dibben MS Excel MVP On Tue, 17 Nov 2009 06:19:02 -0800, Robert wrote: I have a spreadsheet with multiple columns of data. Some of the columns contain data that I want a user to be able to enter data in. There are other columns that are formulas that derive a value based on the user entered data in the other columns in that row. I want to protect the formula columns so I have them locked. All other modifiable columns I've unlocked. The problem is that once I set the protection accordingly I am unable to insert a row even if I've checked the Insert Row allowable function when setting the protection. Is it possible to insert a row that has a locked cell in the row with protection set? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert rows in locked worksheet - from Excel 2003 to 2000 | Excel Discussion (Misc queries) | |||
locked cell not locked | Excel Discussion (Misc queries) | |||
How can I insert and delete rows within a locked cell range column | Excel Worksheet Functions | |||
Insert symbol into locked and protected spreadsheet | Excel Discussion (Misc queries) | |||
insert commnets in locked cells | Excel Worksheet Functions |