Static Macro Buttons

[kingdt]

I have a worksheet with 3 macro buttons. What i want to do is have the macro buttons stay in the same place when i scroll accross and down the page.

I can't use freeze panes as there are some column headings that need to use freeze panes but they need to be able to scroll accross.

Is there some vba code that will do this?

Thanks

[dominicb]

Good afternoon kingdt

Is there some vba code that will do this?]Is there some vba code that will do this?

No there isn't.
Two possible options to think about.
(1) Build a toolbar - this will "float" abouve your worksheet wherever you scroll.
(2) Put your controls in a small userform set to modelesss (so that the user can scroll to their hearts content whilst the form is visible) and have that always on show.

HTH

DominicB

[kingdt]

The toolbar option won't do but the userform sounds like a winner. I have seen these on the VBA screen but have never used them. Are they quite easy to use/how do you display them on the worksheet?

[VBA Noob]

Or a third option.

Your own custom Menu

http://www.j-walk.com/ss/excel/tips/tip53.htm

VBA Noob

[dominicb]

Hi kingdt

Extremely easy. From the VBE just go to Insert > UserForm, and drag the controls into the blank form and resize it. Double click on any control to open the code container for that object.

Have a look at the example userform I've attached to get you started.

HTH

DominicB