View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
yogesh yogesh is offline
external usenet poster
 
Posts: 1
Default my sheet is locked and protected, i want to insert row with autofo

i have created a new sheet, the column A7 to A9 contains standard formulas
which i had assigned there. i dont want any one should see this formula so i
had hide and locked them and then protected sheets with passsword setting.
now when i am trying to insert new row, i want the above formula should get
copied in new row. how this is possible. i am trapped, tried a lot but no
solution i am yet having. kindly assisst