| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move Control with Scroll
Excel 2003
I have a long worksheet with a ControlButton on it, located near the start of the WorksheetSheet. If I scroll down, the control stays where it is and soon disappears from sight. How can I make the CB move with the sheet, so that It is always visible? donwb |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Move Control with Scroll
Put your control on a button on a toolbar rather than on the worksheet.
-- Gary''s Student - gsnu2007h "donwb" wrote: Excel 2003 I have a long worksheet with a ControlButton on it, located near the start of the WorksheetSheet. If I scroll down, the control stays where it is and soon disappears from sight. How can I make the CB move with the sheet, so that It is always visible? donwb |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Move Control with Scroll
Thanks Garry's student.
Using a toolbar on the worksheet is the answer. It moves with the scroll. "Gary''s Student" wrote in message ... Put your control on a button on a toolbar rather than on the worksheet. -- Gary''s Student - gsnu2007h "donwb" wrote: Excel 2003 I have a long worksheet with a ControlButton on it, located near the start of the WorksheetSheet. If I scroll down, the control stays where it is and soon disappears from sight. How can I make the CB move with the sheet, so that It is always visible? donwb |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel-how to get the spreadsheet to move as I move the scroll tab | Excel Discussion (Misc queries) | |||
| Scroll bar (control) doesn't scroll!! ??? | Excel Programming | |||
| Scroll bar (control) doesn't scroll!! ??? | Excel Worksheet Functions | |||
| Scroll bar control doesn't scroll !! ??? | Setting up and Configuration of Excel | |||
| When I move scroll bar in excell the contents do not move with it | Excel Discussion (Misc queries) | |||
Linear Mode
