Answer to my own question:
Here's what I did:
Earlier when I posed my question, the macro I refered to in order t
test code validity was named Delete (how original!)...code as follows:
Sub Delete()
Dim cbWSMenuBar As CommandBar
On Error Resume Next
Set cbWSMenuBar = CommandBars("Worksheet Menu Bar")
cbWSMenuBar.Controls("Britannia").Delete
End Sub
the BeforeClose sub now looks like the following:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Call Delete
End Sub
Works just fine. Hope this helps someone.
Ro
--
Message posted from
http://www.ExcelForum.com