Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
Macros: Step Thru Works, Run Works, Keyboard Shortcut Locks up | Excel Programming | |||
UDF Works in Debug Window but not on Sheet? | Excel Programming | |||
How do I convert works file to excel without works software? | Excel Discussion (Misc queries) | |||
Using a save window with VB that works | Excel Programming |