How to close a toolbar on exit of workbook - current code not work
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
|