View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lisa[_3_] Lisa[_3_] is offline
external usenet poster
 
Posts: 11
Default Adding Row on a protected wkbk

I have several staff that use wook books (wkbk) to keep track of there
clients. The cells with the formulas are protected, because they keep
typing over them and then do not know how to put them back in.

They often add and delete rows, which I have allowed them to do while still
protecting the formula cells.

How do I get the formual to duplicate in a row that has been added with out
having the formual cell unprotected.
--
Lisa M.