View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Insert Rows in Protected Worksheet

ActiveSheet.Unprotect Password:="your password goes here"
'code goes here
ActiveSheet.Protect Password:="your password goes here"