View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RKS RKS is offline
external usenet poster
 
Posts: 63
Default Copy format & formula

I want to distribute a payroll worksheet to a Users to Update details.
I protect sheet & hide the formula. when user inset the row for new man
joing, how can copy the formula with previous column. I don't want to see
formula to anyone.

Thanks RKS