LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Checkbox works in one window but not another

Maybe you could replace the checkboxes from the Control toolbox toolbar with
checkboxes from the Forms toolbar.

You'll have to fiddle with the code, but the controls from the Forms toolbar may
work.

pdberger wrote:

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


--

Dave Peterson
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
The window opens in a smaller window not full sized window. Rachael Excel Discussion (Misc queries) 0 November 7th 06 09:04 PM
Macros: Step Thru Works, Run Works, Keyboard Shortcut Locks up BEEJAY Excel Programming 2 October 3rd 06 06:46 PM
UDF Works in Debug Window but not on Sheet? Andibevan Excel Programming 2 September 26th 06 11:42 AM
How do I convert works file to excel without works software? CatMB Excel Discussion (Misc queries) 1 June 21st 05 04:12 PM
Using a save window with VB that works Trainer Dan Excel Programming 1 June 10th 05 10:35 PM


All times are GMT +1. The time now is 01:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"