Active X controls

[jules]

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.

 

[Bob Phillips]

You could use Windows>Freze 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]

Thanks for the info, but I wanted to know if there some
way to do programmatically?

Jules

 

[Bob Phillips]

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)