Floating Buttons

[dbuttery1]

Is ther any way to create a button that always stays on the screen.
i.e. it is not locked on to a specific cell and will remain in view even if i scroll way down the screen.

Right now i have multiple buttons that do the same thing all over my sheet for speed but one that always stayed in view would be much better.

Thanks

[mikerickson]

If you are using pre-2007, you could create a custom toolbar and put your buttons on that. (There's probably a way in 2007 that I'm unaware of.)

The tricky part is that the custom toolbar is part of the Application and not the workbook containing your macros. I use Workbook_Activate and _Deactivate routines to show/hide the toolbar when appropriate.

[Andy Pope]

Another option would be to place all the buttons and the top of the sheet and then freeze the first row or two.

[dbuttery1]

I guess excel is not magic.

Thanks for the ideas.