prevent second copy from opening
 

Basically, is there a way to check if a workbook with the
same name is already opened and if it is, do not try to
open a new instance.

You can't have two workbooks open with the same name.

You could have your workbook open event see if a version of the menu is
already present.

On error resume next
set obar = Commandbars("Worksheet Menu Bar").Controls("My Menu")
On Error goto 0
if obar is nothing then
' create the meny
End if



Regards,
Tom Ogilvy

"Derek" wrote in message
...
I have a workbook that uses the workbook_open event to
call a procedure to create a menu. When I try to open a
second instance of the workbook I get an error. It looks
like the second workbook is trying to create the menu
again (I am assuming there is a name conflict).

Basically, is there a way to check if a workbook with the
same name is already opened and if it is, do not try to
open a new instance.