Testing if Commandbar exists
dim myCmdBar as CommandBar
set mycmdbar = nothing
on error resume next
set mycmdbar = application.commandbars("my tools")
on error goto 0
if mycmdbar is nothing then
'doesn't exist
else
'yep, it exists
end if
"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-
--
Dave Peterson
|