Excel VBA - Delete toolbar

[thesteelmaker]

I have created a toolbar, "My Details", with a some marcos in. To ope
some userforms.

The toolbar "My Details" is attached to an Excel file "my work.xls"
and appears when this file is opened.

But the toolbar is still there when i close "my work.xls".

I would like to be able to delete the toolbar after "my work.xls" ha
been closed.

Or have the toolbar only appear when "my work.xls" is open.

Any help.
Thanks

 

[Bob Phillips]

Try adding his code into the ThisWorkbook code module

Private Sub Workbook_BeforeClose(Cancel As Boolean)
On Error Resume Next
Application.CommandBars("My Details").Delete
On Error GoTo 0
End Sub

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)