Logo 
Search:

MS Office Forum

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Excel VBA, is there an "IF" statement verifying toolbar exist

  Asked By: Boell    Date: Dec 29    Category: MS Office    Views: 1190
  

Excel VBA,
is there an "IF" statement verifying that a toolbar exist
in order to delete the toolbar?

Currently I create and then delete the toolbar.
However, sometimes the user interupts the process
and I need to know if the toolbar exist to delete
it ahead of time.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Walborgd Fischer     Answered On: Dec 29

Of course there is but why not:

On Error Resume Next
Application.CommandBars(1).Delete
On Error Goto ErrTrapper

 




Tagged:            

 
 
 
 

Related Post