| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Active X controls
I have command buttons on a worksheet and was wondering if
there is anyway to for the command buttons to stay on the screen when scrolling up/down right/left on the worksheet? I have the position set to free floating, but this option does not solve the problem. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Active X controls
You could use WindowsFreze Panes, and put the button above the freeze.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "jules" wrote in message ... I have command buttons on a worksheet and was wondering if there is anyway to for the command buttons to stay on the screen when scrolling up/down right/left on the worksheet? I have the position set to free floating, but this option does not solve the problem. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Active X controls
Thanks for the info, but I wanted to know if there some
way to do programmatically? Jules -----Original Message----- You could use WindowsFreze Panes, and put the button above the freeze. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "jules" wrote in message ... I have command buttons on a worksheet and was wondering if there is anyway to for the command buttons to stay on the screen when scrolling up/down right/left on the worksheet? I have the position set to free floating, but this option does not solve the problem. . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Active X controls
Don't make them free floating, set the position property to msoBarTop.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "jules" wrote in message ... Thanks for the info, but I wanted to know if there some way to do programmatically? Jules -----Original Message----- You could use WindowsFreze Panes, and put the button above the freeze. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "jules" wrote in message ... I have command buttons on a worksheet and was wondering if there is anyway to for the command buttons to stay on the screen when scrolling up/down right/left on the worksheet? I have the position set to free floating, but this option does not solve the problem. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Command Button Active X controls | Excel Discussion (Misc queries) | |||
| Active X Controls | New Users to Excel | |||
| Active X controls | Excel Discussion (Misc queries) | |||
| Tab Between Active X Controls on Worksheet | Excel Programming | |||
| Populating Active X Controls | Excel Programming | |||
Hybrid Mode
