View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
K Dales K Dales is offline
external usenet poster
 
Posts: 131
Default 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/

.