Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to change syperlink from single click to double click | Excel Worksheet Functions | |||
I click in a cell & it acts like I am holding onto the left mouse | Excel Discussion (Misc queries) | |||
Excel should pan like autocad (click and hold wheel). | Excel Discussion (Misc queries) | |||
Single click event | Excel Programming | |||
Click event on Scrollbar | Excel Programming |