SRGDamia1
commented
9 years ago In order to protect formulas within tables but allow the rest of the table to be editable, I also had to use a macro that modified the base structure of the table. (I found someone else's macro, I did not write it myself. See http://jonvonderheyden.net/excel/allow-auto-fill-formulas-in-a-protected-table/) This makes using undo at any place in the template a little wonky.
I'm using on-change macros [Private Sub Worksheet_Change(ByVal Target As Range)] in the "Sampling Features" worksheet to keep the specimens and sites tables the same length as the SamplingFeatures table. I'm using the same set up to automatically adjust column widths in the "Data Columns" worksheet. While these are nice features, unfortunately using them means that any time either of these vba scripts runs the whole un-do log is cleared. This is kind-of a pain, not crucial, but rather annoying.