A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Locking Worksheets, Copy and Paste Question



 
 
Thread Tools Display Modes
  #1  
Old June 9th, 2009, 04:18 PM posted to microsoft.public.excel.worksheet.functions
Philip
external usenet poster
 
Posts: 96
Default 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  
Old June 9th, 2009, 04:59 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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  
Old June 9th, 2009, 06:48 PM posted to microsoft.public.excel.worksheet.functions
Philip
external usenet poster
 
Posts: 96
Default 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  
Old June 10th, 2009, 03:09 AM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:06 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.