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
|