From Mark Mountain@21:1/5 to All on Fri Jan 20 05:20:35 2023
If some cells in the row are protected with formulas and others aren't. you get the error warning when trying to insert a row. Even more annoyingly is it will still insert a row BUT the inserted row won't copy down the formulas from the cells above. But
when you unprotect it, it does copy the formulas down. But obviously you don't want that unprotected as you leave everything else open to be edited and broken.
As a side note / incase this is causing issues. I set my data entry area as a table as I wanted rows to alternate in colour making it easier to read and when you insert a row I wanted to maintain that alternating colour.
It feels like there is some potential in a VBA code that can;
- Identify when someone is trying to insert a row.
- Unlock the sheet with a pre-known password.
- Insert the row (which will now contain required formulas from above cells as the sheet it unlocked).
- Then lastly re-protect the sheet with the same known password.
However I'm not having much luck with the VBA method so far.