Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
1. Enters an Excel worksheet.
2. A (target) ScrollBar (be it the genre of Control or Form Toolbar) is located (approximately mid-stream) in column-K. 3. Select the ScrollBar and activate short-cut menu, Format Control Properties Check : Don't Move or Size with Cells. 4. Then, scroll the ActiveWindow to the left by a column (after clicking once the Right-Pointing Arrow of the Horizontal ScrollBar). 5. Consequently, column-L scrolls into view ; repetitive clicking as in step-4 follows-suit. 6. As it appears, the (target) ScrollBar continues to shift sideways (to the left hand side of the ActiveWindow) in the midst of column-K until it drops out of the LHS of the screen ; although during the interim, one would have expected that the (target) ScrollBar might be floating over column-L, then Column-M and beyond, it has not happened like that. 7. This query is intent upon a means of keeping the (target) ScrollBar relatively stationary (since its Debut) with reference to the ActiveWindow (despite that the underlying GridLines and hence the Ranges thereof may be wound to the Left or Right and similarly, unwound Up or Down). But, how to accomplish that something just like a Floating Toolbar ? 8. Please share your experience. Regards. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
scrollbar size | Excel Discussion (Misc queries) | |||
scrollbar changes size | Excel Programming | |||
Move or Size Combo Box from forms toolbar With Cells | Excel Discussion (Misc queries) | |||
Can the Combo Box move and size with cells radio button be enable | Excel Worksheet Functions | |||
TextBox Properties -- Don't move and size with cells | Excel Programming |