Your life will become loads easier if you actually create that toolbar each time
the workbook opens and destroy it when the workbook closes.

Then you never have to worry about icons pointing to macros in different
workbooks--'cause your code will assign them to the workbook that's opening.

Here's how I do it:
http://groups.google.co.uk/groups?th...5B41%40msn.com

If you want to add some items to the worksheet menubar, you may want to look at
John Walkenbach's MenuMaker routine.

You can find it:
http://j-walk.com/ss/excel/tips/tip53.htm

CBH wrote:

I have inherited a template to support. It adds a toolbar item to connect to
an Oracle database, and works fine. However, the first time the template is
populated and saved as a spreadsheet, the macros stay linked to that
spreadsheet by name forever more. I can find reference to the spreadsheet
name in the Excel11.XLB file, and if that file is deleted, the cycle begins
again. How can I fix this permanently?

--

Dave Peterson