You can make a brand new toolbar by (1) selecting
Tools/Customize, then (2) selecting the Toolbar tab, then
(3) pressing the "New" button. Give it a name and let it
float or park it anywhere.

It's a little tricky to associate that toolbar with the
particular spreadsheet. I recommend keeping all the time,
but hiding it when it's not in use.

Putting the macro buttons on the new toolbar isn't the
most intuitive thing Microsoft came up with. (a) In the
same dialog box (Tools/Customize) select the "Commands"
tab and in the left list, select "Macros". (b) See the
Smiley face? Drag that to the new toolbar and release it.
(c) Then right click on that new smiley button. At the
bottom of the menu is "Assign Macro...". You should be
able to do that yourself and figure out how to give it a
name.


-----Original Message-----
I have three macros to sort data on a very large
worksheet that I have
made launchable by pushing a button on the worksheet.
Because the
worksheet is so large I am consatntly moving the buttons
around just to
keep them in the relevant field of view. Is there a way
to put the
launch buttons onto a floating toolbar add it to one of
the existing
toolbars?


---
Message posted from http://www.ExcelForum.com/

.