How can I set up a free floating command button?

B

brm101

I would like to set up a command button that moves freely when I scroll
through a spreadsheet.
 
D

Dave Peterson

I think it might be better (pronounced easier) to use a custom toolbar.

Tools|customize|
create a new toolbar
add an icon
assign it your macro
and attach it to your workbook.

If you do attach toolbars to workbooks, you may want to read these notes by
Jan Karel Pieterse:
http://google.com/[email protected]


===
Alternatively, you could build that toolbar on the fly when the workbook opens
(and destroy it when the workbook closes):

If that interests you, here's a post that may help:
http://groups.google.com/[email protected]
 
Top