Moving the Command Button

A

alexm999

I have a spread sheet which is scrolls from Column A to AV.
I have 2 very important command buttons which executes macros.

Is there a way I can get these Command Buttons to "follow" the user if
he/she scrolls either left or right?

For a better example, DHTML lets you scroll menus automatically, can
this be done in Excel?
 
K

K Dales

Don't think it is possible, but I can think of two
alternatives:

1) Put the command button on a userform and set the
userform's ShowModal property to be False
2) Create a custom toolbar and put a button that activates
your macro on the toolbar

The second is the easier of the two - look in Excel help
under "Run a macro from a toolbar button"
 
R

Rob van Gelder

I don't think it's possible to trap a user's scrolling events.

What you could do is create a floating commandbar.
There's a commandbar example on my website: Collection of Buttons.
Just change the Position argument to msoBarFloating.
 
Top