Hi Sharon.
When you created the custom toolbar, the toolbar was saved in "Excel.xlb"
NOT the workbook that was open when you created it. So, when you created the
buttons on the toolbar, you pointed them at the macros in the workbook that
was open at the time. Now, when you open the toolbar (regardless of which
workbooks are open), those macros look for the macros you've assigned to
them...which are in the original workbook. Hope that explains what happened.
To get around this, you might want to put code in the workbook that will
create a toolbar on the fly each time you open the workbook [and destroy it
each time you close the workbook]. That way the code for the toolbar as well
as the macros in the workbook are ALL copied to a new workbook.
John Walkenbach has a couple of excellent books out that explains this
technique.
Check out 'Excel 2003 Power Programming with VBA' at
http://j-walk.com/ss/books/index.htm

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Sharon" wrote:

Sorry to be a pain about this. The custom toolbar I created is displaying
when the workbook opens and hidden when the workbook closes, which is fine.
I then wanted to copy the workbook to another location with another name, and
attached the toolbar to the new workbook. However, the damn thing keeps
looking back to the original workbook for the macros. Is the only way to
create a new toolbar name for each workbook?
--
Sharon