make buttons stay put!

[Dave]

I have inserted some form buttons on a worksheet that start a macro that
does some filtering. In the process of doing the filtering the sheet size
changes, and the buttons move or even disappear. Is there any way to
"freeze" their location on a sheet so they don't jump around?
thanks!

 

[Bob Phillips]

Dave,

If you right-click the buttons, and select the Properties tab, you can
select the option 'Don't move or size with cells'

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Dave]

excellent!......thanks

Dave,

If you right-click the buttons, and select the Properties tab, you can
select the option 'Don't move or size with cells'

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

My pleasure!

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Dave]

it works very well when the button is used to run the macro, but they still
slide up the page when I simply scroll down.....anyway to fix that, and
freeze their location when scrolling?
Thanks again
D