View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
pdberger pdberger is offline
external usenet poster
 
Posts: 258
Default 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