Here is a way to do what you want, there may be others.

Instead of creating a toolbar with all your button on it( it will
always reside in the top of the screen independent of what spreadsheet
file you have open); in the file where you want your macro buttons to
reside, create a textbox for each one - you can assign a macro to a
textbox. The text boxes can only reside within the spreadsheet (they
sit on top of the cells so you will be losing access to some cells).
You can enter what ever text you want to identify the macro and even
color the text and the background to make it stand out from the cells.

Make sure that when you save your macros (for this workbook only) that
you specify "For this workbook". If you already have macros created in
a module under the Personal.xls workbook; you will have to copy and
paste the code into new modules in the specific workbook you want them
in and then delete them from the Personal.xls module list.


--
neopolitan


------------------------------------------------------------------------
neopolitan's Profile: http://www.excelforum.com/member.php...nfo&userid=611
View this thread: http://www.excelforum.com/showthread...hreadid=475781