Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Tag in CommandBar | Excel Programming | |||
cant dim as commandbar | Excel Programming | |||
CommandBar | Excel Programming | |||
Testing to see if a Workbook menu item exists | Excel Programming | |||
Testing to see if a sheet name exists | Excel Programming |