I found through some research that I could use the Data Validation command to protect cells from being change if they have formulas in them. I've created a rather complicated (at least I think so) spreadsheet that other people in my office will have their own copy to keep weekly project status reports. There are several cells that run formulas both across the rows and the columns. These cells all have blue text in them to signify that the information is in fact a formula and does NOT require any input. All other cells are in black and can/should be updated accordingly to produce the end result. The problem is that too many people still use Excel like a piece of graph paper and want to update the formula cells anyway, using such things as calculators, etc. I know, it's ridiculous. So I use the Data Validation>Allow>Custom>Formula and then input the formula for that cell without the "=". If I use the equals function in the Data Validation Formula, the cell can still be modified, but without it cannot. This is great except that when I have a formula such as "=SUM(F6:F28)-F6" and then copy and add an additional 10 rows within this range, the formula does NOT update to a range of F6:F38. Additionally, if I were to copy cell F7 that contains the Data Validated formula of "D7+E7" and paste it in the subsequent cells below it, the formula stays the same all the way down the rows. Clearly, not a good solution. It's only when the "=" function is left in the formula that the Data Validation updates automatically. But again, this leaves the cell vulnerable to changes from unskilled users.

Is there a way to both protect the cells (I've already gone through the Protect Cells/Protect Sheet option but that require macros, etc) but yet still allow insertion of additional rows as more lines of information is required?

Thanks in advance,
Jim