View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_2_] Leith Ross[_2_] is offline
external usenet poster
 
Posts: 128
Default Testing if Commandbar exists

On Sep 17, 6:18 pm, "Farrar Tweety"
wrote:
Can't seem to get a handle on this. How would I test, in VBA, if the
toolbar "My Tools" exists? Any help appreciated, in the meantime I'm going
to keep hammering away.

-gk-


Hello,

Here is a code example...

Dim CmdBar As CommandBar
Dim Exists As Boolean

For Each CmdBar In Application.CommandBars
If CmdBar.Name = "My Tools" Then
Exists = True
Exit Loop
End If
Next CmdBar

Sincerely,
Leith Ross