Hi,

What you can do, is basically "grab" the toolbar out of the book. You can do
this by

ToolscustomiseToolbars (with the book open) highlighting the relevant
toolbar, and clicking on the attach button. This will let you attach the
toolbar (and accompanying macros) into any workbook you want.

Hope this helps

Sunil Jayakumar



"CBH" wrote in message
...

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?

www.ayyoo.com/credit-cards.html