In , Fred
spake thusly:

"Dallman Ross" <dman@localhost. wrote in message
...

To keep the button visible even when the sheet scrolls, go to
Design Mode in the Control toolbox; right-click on your button
and choose "Format Control"; and, under the Properties tab,


That feature is in Excel 2000 but when I tried all of the options
each one did as expected, but only in the position on the
worksheet where the button was located. Unfortunately the button
still scrolls with the sheet.

It would be interesting to know if the feature does lock the
scrolling in Excel 2002.

Okay, you are right in your suspicion, in that in 2002 as well
the button only stays fixed in relation to the cells where it
was placed, but can still be scrolled off the screen.

Perhaps the OP's recommendation to put the button at the top
would be best, then. I noticed another poster -- I think it
was JLatham, but can't look right this second -- tried out his
hand at sime VBA code to make the button part of the toolbar, too.
I actually saved that to try it later, if and when I have a need.

--
dman