Creating two menus

[tryer]

I have a workbook which uses the code below to create a new menu upon opening. I have now used this same code in a second workbook to create a different menu. both work OK on their own However if by chance both workbooks are opened at the same time only one menu is shown.
Is there a way I can change one of these to create a second menu if the first one is already there?

Please Login or Register  to view this content.

[pike]

what about since the menus have the same name add

Please Login or Register  to view this content.

to each workbook
then the subs will only work for the open work book

[tryer]

Thanks for the reply Pike. The thing is I need to be able to have both menu's available if both workbooks are open. However your comments have made me think about names, and I realise that the createmenu sub was named the same in both workbooks so I have cheanged one of them but unfotunately it hasn't cured the problem. When I open the second workbook the first menu is overwritten.

Any further thoughts?

[Andy Pope]

You need to give the menus a different Tag value.

This part removes a menu with the tag "MyTag" in your case they both have the same tag.

Please Login or Register  to view this content.

Don't forget to also change the tag when creating the menu.

[tryer]

Brilliant !!

Thank you Andy that solved it