ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   "Floating" button (https://www.excelbanter.com/excel-discussion-misc-queries/64850-floating-button.html)

Brisbane Rob

"Floating" button
 

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


TomHinkle

"Floating" button
 
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

"Floating" button
 
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


All times are GMT +1. The time now is 08:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com