Float a command button to appear on all sheets? 1

[wotgoesup]

I've had great answers in the past, so let's try this one:
I have 4 sheets in a workbook, named A - D.
I want to have 4 buttons, each with a macro that activates a specific sheet, and selects a specific cell.
I know that my users can click on say, sheet A, but I want them to see a button on sheet B, C, D that they click to take them to a specific cell on sheet A. Ideally, there is a floating menu visible on all sheets with 4 choices, each taking the user to a different, specific location.
Writing the macro isn't the problem, but is it possible to "float" the button(s)?

 

[pbrodsky]

Just create a custom toolbar and put your commands on that.

 

[Gavona]

Or maybe use hyperlinks (Insert, Hyperlink) one per cell - Window, FreezePanes to make sure they are always visible.

Gavin

 

[SkipVought]

Hi,

You can also code a UserForm with ShowModal FALSE.

Skip,
[sub]
[red][/red]
[/sub]