Control Button stays on screen
 

Here's an idea I have that will probably be more annoying
than anything else, but I'm wondering if someone can tell
me how it could be done.

Is there a way to have a command button stay in the
active window when the user scrolls around in the
worksheet?

tod

Control Button stays on screen
 

Tod, if it is a button on a worksheet, you could put it at A1 and then
freeze panes below it (and to the right. That keeps it visible all the tme.

Robert Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Tod" wrote in message
...
Here's an idea I have that will probably be more annoying
than anything else, but I'm wondering if someone can tell
me how it could be done.

Is there a way to have a command button stay in the
active window when the user scrolls around in the
worksheet?

tod

Control Button stays on screen
 

Aside from the given suggestion, you can use a new
commandbar containing just this button
(commandbarbutton/toolbarbutton) which will stay put.

-----Original Message-----
Here's an idea I have that will probably be more annoying
than anything else, but I'm wondering if someone can tell
me how it could be done.

Is there a way to have a command button stay in the
active window when the user scrolls around in the
worksheet?

tod
.