ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Adding Row on a protected wkbk (https://www.excelbanter.com/excel-discussion-misc-queries/180091-adding-row-protected-wkbk.html)

Lisa[_3_]

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.


All times are GMT +1. The time now is 11:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com