The current version of the time series template is being posted with worksheet protection turned off. Have we definitely decided that the bugs related to worksheet protection were insurmountable and the sheets should be unprotected ? If the workbook is unprotected, then its very easy for the user to change (and mess up) formulas.
#18 was a protection issue and the macro that causes that bug actually doesn't wholly solve the issue with adding rows to tables in protected worksheets.
I'm okay with leaving the workbook and all worksheets unprotected, but if we're going to make that decision, all of the macros should be cleaned up because they all have steps in them relating to protecting and un-protecting worksheets. The entire macro mentioned in #18 should also be removed as well.
The current version of the time series template is being posted with worksheet protection turned off. Have we definitely decided that the bugs related to worksheet protection were insurmountable and the sheets should be unprotected ? If the workbook is unprotected, then its very easy for the user to change (and mess up) formulas.
#18 was a protection issue and the macro that causes that bug actually doesn't wholly solve the issue with adding rows to tables in protected worksheets.
I'm okay with leaving the workbook and all worksheets unprotected, but if we're going to make that decision, all of the macros should be cleaned up because they all have steps in them relating to protecting and un-protecting worksheets. The entire macro mentioned in #18 should also be removed as well.