View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Joseph Tom Joseph is offline
external usenet poster
 
Posts: 51
Default 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