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.

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.

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.


.

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.


.