How to close a toolbar on exit of workbook - current code not work
Your code should work fine assuming a commandbar with that name exists.
Unless certain, normally best to use
On Error resume next
' delete code
On Error goto 0
Maybe you have the commandbar "attached" to a workbook which is causing
confusion.
Regards,
Peter T
"Tom Joseph" wrote in message
...
Can someone please help me? The following code is not working. I would
like
to close a toolbar on exit of a workbook.
Thanks.
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Call DeleteBar
End Sub
Sub DeleteBar()
Application.CommandBars("Dashboard Controls").Delete
End Sub
|