View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
puting_uwak[_2_] puting_uwak[_2_] is offline
external usenet poster
 
Posts: 9
Default insert row and copy formula in protected worksheet

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"