Checkbox works in one window but not another
Dave --
I wish I could freeze the panes. It's a time card, and the various users
want to see hours per day, per client, etc., etc., etc. so if I showed all
that and froze the panel, there wouldn't be any lines showing as they
scrolled down.
Bummer about the "feature/bug". Thanks for the info, so I don't beat myself
up trying to solve it.
"Dave Peterson" wrote:
It's a "feature/bug" of split windows.
Maybe you can use freeze panes and put the control at the top???
pdberger wrote:
Good afternoon --
I've designed a workbook to have checkboxes on two worksheets. Then, I
wrote a macro to open the workbook in two tiled windows (so that reference
info stays visible in one window when the other scrolls as the user adds more
info).
My problem -- the checkboxes on Sheet 1 work fine, but the checkboxes on
Sheet2 don't. They only work when I switch to the other window and go that
same sheet Whoda thunk?
Very simple code. If the box is checked, place a value in a particular
cell. But the box is unresponsive on one (active) window and, when I make
the other window active and go to that sheet, it works just fine. Any idea
what might be happening here?
TIA
--
Dave Peterson
|