i have a worksheet with locked columns containing formulas. how can i insert
rows & copy the formula above without having to unprotect the worksheet?

In some versions of excel, you can allow the user to insert rows or columns when
you protect the sheet. Make sure that all the rows/columns in that allowed
range are unlocked.

puting_uwak wrote:

i have a worksheet with locked columns containing formulas. how can i insert
rows & copy the formula above without having to unprotect the worksheet?

--

Dave Peterson

"Dave Peterson" wrote:

In some versions of excel, you can allow the user to insert rows or columns when
you protect the sheet. Make sure that all the rows/columns in that allowed
range are unlocked.

but i need to have locked cells stay that way to prevent other users from
changing the formulas and data in those cells. i tried recording a macro but
i can't bypass unprotecting the sheet. by the way, i'm using excel 2007.

thanks for replying! :)

You could add some code to your macro:

activesheet.unprotect password:="topsecret"
'your code here
activesheet.protect password:="topsecret"



puting_uwak wrote:

"Dave Peterson" wrote:

In some versions of excel, you can allow the user to insert rows or columns when
you protect the sheet. Make sure that all the rows/columns in that allowed
range are unlocked.

but i need to have locked cells stay that way to prevent other users from
changing the formulas and data in those cells. i tried recording a macro but
i can't bypass unprotecting the sheet. by the way, i'm using excel 2007.

thanks for replying! :)

--

Dave Peterson

added your code to my macro and it worked! :) thanks for your help!


"Dave Peterson" wrote:

You could add some code to your macro:

activesheet.unprotect password:="topsecret"
'your code here
activesheet.protect password:="topsecret"

Hi there!

Is there anyway to do this without macro? I'm an idiot in macro....

I need to be able to insert new rows in protected sheets. The inserted rows should have the formulas.. please help ..