Non of this is functioning correctly at all.
The Sheet Protection should "only" change IF
- If the SubTotal for (last) row (which should start out 0.00) in column (K, L or M [depending on the sheet]) changes "Then", code fires to:
- UnProtect, Insert row xlDown+1, Copy formula - format and validation (all properties)."Then"
- Protect sheet
The protection should be removed "ONLY" If the last cell in the SubTotals range changes from "0.00" and then all "cell properties" should be restored after the rowInsert function is complete.
The user must be able to evaluate or change any data they enter without affecting the protected areas.Example:
In the event of an audit: the user can give the WorkBook to a CPA or IRS agent for evaluation and comparison to hard copies of the documentation and no change can be made without releasing the protection.
As it stands now. If the sheet is active you can clickon (or activate) cells that should be locked, including the header and deadzone areas.
can the deadzone (area outside of the worksheet) be named so you can add code to lock it down.
Don't know what you mean by this line
The DeadZone is the area outside of the "sheet data entry area" (the Dark Green cells. They should Stay locked, except during the insert row function.
At this point they get unlocked any time the sheet is active.