Control Button stays on screen

T

Tod

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
 
B

Bob Flanagan

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
 
B

Bob Umlas Excel MVP

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