K
Ken Shaffer
I'm modifying John Walkenbach's example spreadsheet which generates a
calendar based on months and years selected by a scrollbar. My modifications
include lookups to another worksheet in order to fill in text for the date
of interest.
My problem is that now, for some reason, a single click to change a month,
acts like I've held the button down and I don't know why. Near as I can
tell, there is no code associated with the scrollbar, so it must be handled
internally by Excel. The only code is a startup macro setting the current
month and year and another macro to protect/unprotect the worksheet. I've
changed neither of these macros. I have not added any other VB code, I
simply created other array formulas to access another sheet based on the
date and another define which defines a crlf as =char(10). I've also
formatted the cells to autowrap so that my text can be separated as needed
by the crlf define.
Has anyone seen this before and is there a solution?
Thanks,
Ken Shaffer
calendar based on months and years selected by a scrollbar. My modifications
include lookups to another worksheet in order to fill in text for the date
of interest.
My problem is that now, for some reason, a single click to change a month,
acts like I've held the button down and I don't know why. Near as I can
tell, there is no code associated with the scrollbar, so it must be handled
internally by Excel. The only code is a startup macro setting the current
month and year and another macro to protect/unprotect the worksheet. I've
changed neither of these macros. I have not added any other VB code, I
simply created other array formulas to access another sheet based on the
date and another define which defines a crlf as =char(10). I've also
formatted the cells to autowrap so that my text can be separated as needed
by the crlf define.
Has anyone seen this before and is there a solution?
Thanks,
Ken Shaffer