Generally, it would be something like

On Error Resume Next
Set oCB = Application.CommandBars("myReports")
On Error GoTo 0

If oCB Is Nothing Then
'CreateIt
End If

but show us the code if this doesn't solve it

--

HTH

RP

"kraljb" wrote in message
...

I am not a programmer, but somehow I got assigned this task for knowing
enough about excel functions.


I am having an issue, where I have a general custom menu called Reports
where I have a few macros running reports for a few people. However,
different people within that group have individual reports, as well as
individuals that do not have the general reports may have an individual
one.

The problem I am running into, while trying to be consistent across the
board, is that all the reports (individual or general) are trying to use
the same menu name: "Reports" so if an individual has multiple reports
from seperate macros they end up with 2-3 different menu choices when
all three macros are opened. I need a way to say If
reportmenudoesnotexist Then create reportmenu End If.


--
kraljb
------------------------------------------------------------------------
kraljb's Profile:
http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=272466