Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
prevent workbook opening if already open by someone else | Excel Discussion (Misc queries) | |||
Prevent worksheet from opening in a workbook | Excel Worksheet Functions | |||
How to prevent any one from opening my workbook | New Users to Excel | |||
prevent second copy from opening | Excel Programming |