View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] willjohnson33@yahoo.com is offline
external usenet poster
 
Posts: 15
Default Trouble removing toolbar - why won't my code work?

I have the code below in an add-in that I have created. The toolbar I
am trying to close is from a third-party add-in that I use and I cannot
get into their code. When I close the toolbar and re-open excel the
toolbar comes up again. If I run the code after excel is open then the
code works fine so this add-in must be the last to run. Is there a way
to run my add-in after all other add-ins are run? I think that would
solve the problem.

Private Sub Workbook_Open()
Application.CommandBars("Custom Toolbar").Visible = False
End Sub

Thanks