On Dec 29, 9:17*am, Gord Dibben <gorddibbATshawDOTca wrote:
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.- Hide quoted text -

- Show quoted text -

Thanks for the reply. They've sure figured out how to make it way more
complicated, haven't they? Another M$ dehancement to Office 2003!
Happy Holidays.