insert row and copy formula in protected worksheet

[puting_uwak]

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]

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]

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]

You could add some code to your macro:

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

 

[puting_uwak]

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