[SOLVED] Expand Date Scroll Bar Automatically to Include New Table Rows

The attached spreadsheet is the work of PK (link in the spreadsheet); to which I have made a few changes. I converted the data on the Data sheet tab to a table so the formulas in columns "Left Padding" and "Space" update when new rows of data are added. What does not update is the "Change Dates" scroll bar to add the new date. For instance, 18-Feb-21 is not selectable. To update to include new dates I have to manually update the format control of the scroll bar. Is there a possible workaround for this? Or should/could this be done with a spinner? Your thoughts? Thank you.

On sheet("data"), I used cell M1 (named it "TotalDays") to calculate column A max date - min date.
I used the sheet("data") change event to set the scrollbar max value to TotalDays'

Please Login or Register  to view this content.