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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula from consecutive rows to alternate rows? 2
how do I insert row keeping formulas from previous row? 1
Excel Moving data to sheet2 from sheet1 0
hide, unhide column or row after protect worksheet 4
corrupted formula in protected worksheet 21
Auto fill formulae when inserting rows 9
Excel 2000 Lists - Insert Row in Protected worksheet 1
Excel VBA 1

Back
Top