"Floating" button

[Brisbane Rob]

Is there anyway to have a 'floating' button which runs a macro? In a large spreadsheet, I have buttons positioned at various points which will take the user back to a menu, but one 'floating' button which is always on the viewer's screen would be way cooler?

Thanks for any ideas.

[TomHinkle]

Freeze panes at B10... put buttons over cells A1:a10...
I've done that as a simple workaround

"Brisbane Rob" wrote:

>
> Is there anyway to have a 'floating' button which runs a macro? In a
> large spreadsheet, I have buttons positioned at various points which
> will take the user back to a menu, but one 'floating' button which is
> always on the viewer's screen would be way cooler?
>
> Thanks for any ideas.
>
>
> --
> Brisbane Rob
> ------------------------------------------------------------------------
> Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
> View this thread: http://www.excelforum.com/showthread...hreadid=500799
>
>

[Dave Peterson]

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

Brisbane Rob wrote:
>
> Is there anyway to have a 'floating' button which runs a macro? In a
> large spreadsheet, I have buttons positioned at various points which
> will take the user back to a menu, but one 'floating' button which is
> always on the viewer's screen would be way cooler?
>
> Thanks for any ideas.
>
> --
> Brisbane Rob
> ------------------------------------------------------------------------
> Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
> View this thread: http://www.excelforum.com/showthread...hreadid=500799

--

Dave Peterson