If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Locking Worksheets, Copy and Paste Question
Hi,
I would appreciate any help you can give with my following question. I am trying to lock different sections within a worksheet, and I am wondering if there is a way to lock a worksheet but still allow a user to insert rows and copy and paste formulas into those newly inserted rows. Thank you again for your help. Philip |
#2
|
|||
|
|||
Locking Worksheets, Copy and Paste Question
When protecting a worksheet you can select various options including insert
rows and columns and select locked and unlocked cells. In order to paste into newly inserted rows these inserted rows must lie within the unlocked sections of the sheet i.e. unlock A110 and protect the sheet but allow insert rows. Insert a row at A3.................you can copy/paste into that row in columns A only. Insert a row at A14...........you cannot copy/paste into that row. Gord Dibben MS Excel MVP On Tue, 9 Jun 2009 08:18:01 -0700, Philip wrote: Hi, I would appreciate any help you can give with my following question. I am trying to lock different sections within a worksheet, and I am wondering if there is a way to lock a worksheet but still allow a user to insert rows and copy and paste formulas into those newly inserted rows. Thank you again for your help. Philip |
#3
|
|||
|
|||
Locking Worksheets, Copy and Paste Question
Hi Gord,
Thank you for taking the time to reply, I really do appreciate it. I understand that we can lock a worksheet and insert rows, however do you know if it is possible to insert rows and copy and paste formulas from the above row into the newly inserted row? In other words, I have a worksheet that has multiple data entry fields (both manual and calculated through formuals)... If I insert a row in a locked worksheet, is it possible to transfer the formula from the surrounding rows into the new row? (sorry this is somewhat hard to explain, please let me know if you need further clarification) Thank you again, Philip "Gord Dibben" wrote: When protecting a worksheet you can select various options including insert rows and columns and select locked and unlocked cells. In order to paste into newly inserted rows these inserted rows must lie within the unlocked sections of the sheet i.e. unlock A110 and protect the sheet but allow insert rows. Insert a row at A3.................you can copy/paste into that row in columns A only. Insert a row at A14...........you cannot copy/paste into that row. Gord Dibben MS Excel MVP On Tue, 9 Jun 2009 08:18:01 -0700, Philip wrote: Hi, I would appreciate any help you can give with my following question. I am trying to lock different sections within a worksheet, and I am wondering if there is a way to lock a worksheet but still allow a user to insert rows and copy and paste formulas into those newly inserted rows. Thank you again for your help. Philip |
#4
|
|||
|
|||
Locking Worksheets, Copy and Paste Question
See David McRitchie's site for a macro which inserts a row or rows and
copies the formulas from above. http://www.mvps.org/dmcritchie/excel/insrtrow.htm Gord On Tue, 9 Jun 2009 10:48:01 -0700, Philip wrote: Hi Gord, Thank you for taking the time to reply, I really do appreciate it. I understand that we can lock a worksheet and insert rows, however do you know if it is possible to insert rows and copy and paste formulas from the above row into the newly inserted row? In other words, I have a worksheet that has multiple data entry fields (both manual and calculated through formuals)... If I insert a row in a locked worksheet, is it possible to transfer the formula from the surrounding rows into the new row? (sorry this is somewhat hard to explain, please let me know if you need further clarification) Thank you again, Philip "Gord Dibben" wrote: When protecting a worksheet you can select various options including insert rows and columns and select locked and unlocked cells. In order to paste into newly inserted rows these inserted rows must lie within the unlocked sections of the sheet i.e. unlock A110 and protect the sheet but allow insert rows. Insert a row at A3.................you can copy/paste into that row in columns A only. Insert a row at A14...........you cannot copy/paste into that row. Gord Dibben MS Excel MVP On Tue, 9 Jun 2009 08:18:01 -0700, Philip wrote: Hi, I would appreciate any help you can give with my following question. I am trying to lock different sections within a worksheet, and I am wondering if there is a way to lock a worksheet but still allow a user to insert rows and copy and paste formulas into those newly inserted rows. Thank you again for your help. Philip |
Thread Tools | |
Display Modes | |
|
|