Macro for floating button

[Gilbert]

I created a macro and assigned it to a form button in excel 2007. What I
would like if for this button to move (up or down) the same direction that
I'm scrolling. Is this possibly?

 

[Gord Dibben]

Place the button in row 1 then freeze panes.


Gord Dibben MS Excel MVP

 

[Gary''s Student]

An alternative is to put the button on a custom toolbar, since toolbars are
easy to float.

 

[Harald Staff]

Put it on a modeless userform. Or onto the ribbon.

HTH. Bst wishes Harald

 

[Gilbert]

I apologize for not responding sooner but I still wanted to thank you for
your suggestion.

 

[Gilbert]

I apologize for not responding sooner but I still wanted to thank you for
your suggestion. But how can I make the toolbar float in 2007?

 

[Gilbert]

I apologize for not responding sooner but I still wanted to thank you for
your suggestion. I'm not familiar with modeless userform, how do I use that?

 

[Dave Peterson]

If all your users are running xl2k or higher, you can add a parm on the .show
statement.

UserForm1.Show False

See VBA's help for more info.

 

[Dave Peterson]

Actually, excel's VBA has its own constants for use with .Show.

Constant Value Description
vbModal 1 UserForm is modal. Default.
vbModeless 0 UserForm is modeless.

So I should have suggested:
UserForm1.Show vbmodeless

(False will be treated as 0, so it'll work, but it's less descriptive.)