Thank you for your help. I've had a similar answer from
SteveB, but had some additional concerns about this
method. If you see what I wrote in reponse to SteveB, I
wonder what you would think.

Thanks again.

Linda
-----Original Message-----
Assign and unassign the macros when the workbook is
opened or closed.

Sub Auto_open()
Toolbars("LogForm").Visible = True
Toolbars("LogForm").ToolbarButtons(1).OnAction
= "PhoneLogger"
Toolbars("LogForm").ToolbarButtons(2).OnAction
= "LateLogger"
End Sub
Sub Auto_close()
On Error Resume Next
Toolbars("LogForm").ToolbarButtons(1).OnAction = ""
Toolbars("LogForm").ToolbarButtons(2).OnAction = ""
Toolbars("LogForm").Visible = False
Toolbars("LogForm").Delete
On Error GoTo 0
End Sub

HTH, Greg

"Linda" wrote in message
...
I've created a Excel template with a number of macros
to
run functions in this system. I've created a custom
toolbar to run a number of these macros. The problem
I've encountered is that the toolbar will become
attached
to a workbook saved from this template and when the
template is opened next, the toolbar buttons cause the
old worksheet to open and the macros running from the
toolbar are in the old book and not the new one.

I've tried "attaching" the toolbar; opening and closing
the toolbar when the workbooks open and close; and
deleting the toolbar every time a workbook closes.
None
of these things have solved the problem.

Does anyone have a fuller understanding of how to make
a
custom toolbar run properly with templates and
workbooks
created from this template?


.