Excel 2003 - VBA - ToolBar Release

  • Thread starter Thread starter C Brandt
  • Start date Start date
C

C Brandt

Thanks to all your help, I now have a functioning toolbar that makes life a
lot easier for my users.

But...

now that I have it, how do I get rid of it?

I tried :

Private Sub WorkbookBeforeClose()
Application.CommandBars("Account Review").Visible = False
End Sub

in the "ThisWookbook" object, but that does not seem to be doing the job.
The toolbar is always hanging around unless I go and manually uncheck it in
the toolbars menus.

I would like it to be available when the workbook is open and closed when
the workbook is closed.

Thanks for any help,
Craig
 
See those dropdowns at the top of the code window.

You can use them to choose the name of the procedure you want to use--you don't
have to type it yourself and take a chance of a typo:

Private Sub Workbook_BeforeClose(Cancel As Boolean)

or was this a typo in the newsgroup post?????
 
Thanks for the input.
Wherever I looked, I kept seeing WorkbookBeforeClose without the dash. I
never realized that "thisworkbook" was already preloaded with the procedures
setup.
Thanks again,
Craig
 
Back
Top