Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving the Command Button
I have a spread sheet which is scrolls from Column A to AV.
I have 2 very important command buttons which executes macros. Is there a way I can get these Command Buttons to "follow" the user if he/she scrolls either left or right? For a better example, DHTML lets you scroll menus automatically, can this be done in Excel? --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving the Command Button
If I understand what you mean, this is not possible.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "alexm999 " wrote in message ... I have a spread sheet which is scrolls from Column A to AV. I have 2 very important command buttons which executes macros. Is there a way I can get these Command Buttons to "follow" the user if he/she scrolls either left or right? For a better example, DHTML lets you scroll menus automatically, can this be done in Excel? --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving the Command Button
Don't think it is possible, but I can think of two
alternatives: 1) Put the command button on a userform and set the userform's ShowModal property to be False 2) Create a custom toolbar and put a button that activates your macro on the toolbar The second is the easier of the two - look in Excel help under "Run a macro from a toolbar button" -----Original Message----- I have a spread sheet which is scrolls from Column A to AV. I have 2 very important command buttons which executes macros. Is there a way I can get these Command Buttons to "follow" the user if he/she scrolls either left or right? For a better example, DHTML lets you scroll menus automatically, can this be done in Excel? --- Message posted from http://www.ExcelForum.com/ . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving the Command Button
I don't think it's possible to trap a user's scrolling events.
What you could do is create a floating commandbar. There's a commandbar example on my website: Collection of Buttons. Just change the Position argument to msoBarFloating. -- Rob van Gelder - http://www.vangelder.co.nz/excel "alexm999 " wrote in message ... I have a spread sheet which is scrolls from Column A to AV. I have 2 very important command buttons which executes macros. Is there a way I can get these Command Buttons to "follow" the user if he/she scrolls either left or right? For a better example, DHTML lets you scroll menus automatically, can this be done in Excel? --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command buttons linked to moving rows | Excel Discussion (Misc queries) | |||
command button add another command | Excel Discussion (Misc queries) | |||
Command Buttons on Sheet moving with cells | Excel Programming | |||
Command Button vs Control Button | Excel Programming | |||
Command Button vs Form Button | Excel Programming |