' when opening new one in a different sheet. ' ' 1.0 Oct 27, 2022 initial version. ' Private Const DP_DAY_PREFIX As String = "SSDP_Calendar_DAY_" Private Const DP_DAY_COLUMNS As Integer = 7 Private ...

Const DATEPICKER_TARGET = "A2,B5:B10" 'target cells Private Sub Worksheet_SelectionChange(ByVal target As Range) If Not Application.Intersect(Range(DATEPICKER_TARGET), Range(target.address)) Is ...