Put your macros in a new workbook.
Use code to create the toolbar when that workbook opens.
Save the workbook as an add-in and load through ToolsAdd-ins.
For code to create a Toolbar see Debra Dalgleish's site.
http://www.contextures.on.ca/xlToolbar02.html
John Walkenbach's menumaker workbook is also a good source for creating
toolbars.
http://j-walk.com/ss/excel/tips/tip53.htm
Gord Dibben MS Excel MVP
On Mon, 29 Dec 2008 07:50:03 -0800 (PST), davegb
wrote:
I was just upgraded from Office 2000 to Office 2003 here at work. (I
know, this is the state!) In XL2000, I could create tools and put them
on the standard toolbar permanently, but I can't seem to do this with
XL2003. I think it's because it now longer calls for the "PERSONAL"
workbook where all the macros behind the buttons lived. Is there a
workaround for this? If I can't get the tools in the existing
toolbars, can I make a custom toolbar that automatically comes up when
I open XL?
Thanks again.