software

I need to protect the formatting amp; formula in each cell to avoid accidental
changes during update by different users. However, if I protect them, any
new row creation and deletion are disable. Is there any way resolve it?
Especially, when create a row, how can all formatting and formula to create
automatically for the new row?

Thanks,

Scott
What version of Excel?quot;Scottquot; gt; wrote in message
...
gt;I need to protect the formatting amp; formula in each cell to avoid accidental
gt;changes during update by different users. However, if I protect them, any
gt;new row creation and deletion are disable. Is there any way resolve it?
gt;Especially, when create a row, how can all formatting and formula to create
gt;automatically for the new row?
gt;
gt; Thanks,
gt;
gt; Scott
gt;