insert row and copy formula in protected worksheet

  • Thread starter Thread starter puting_uwak
  • Start date Start date
P

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?
 
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.
 
Dave Peterson said:
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.
Click to expand...

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"
 
Back
Top