one button that moves to selected sheet

smiler44

Registered User.
Local time
Today, 17:20
Joined
Jul 15, 2008
Messages
690
I have a work book with about 20 sheets. I would like to add just one command button. I would like this button to be available no matter which sheet is selected, bit like a floating button. I know I can add a button to each sheet but want to avoid this.
Thanks
smiler44
 
I'm pretty sure you would have to add a button to the ribbon that calls a sub.

I know of no way to create what essentially would be a floating button.
 
I've cheated. I added a user form and a command button to the user form. all I do is keep the user form on top which is sized to the command button.:)

smiler44
 

Users who are viewing this thread

Back
Top Bottom