Concurrent Workbook Menu Generation.

**gajendra.gupta** · 02-16-2007, 12:23 AM

Hi,

I am creating and destroying some Menus in a particular workbook through some VBA code and that code I have written in the Auto_Open and Auto_Close. My problem is when apart from this workbook when I open another Excel Workbook the same menus gets created in it which I do not want. Any clues why it is happening and how can I prevent it?

Regards,
Gajendra Gupta

**Leith Ross** · 02-16-2007, 04:01 AM

Hello Gajendra.gupta,

Your menus are part of the Excel application object and not the workbook object. You need to remove the menus you have added before you open the new workbook. Place the code to remove the menus in the Workbook_BeforeClose event.

Sincerely,
Leith Ross

**gajendra.gupta** · 02-16-2007, 05:50 AM

Leith, Thanks for your reply but it does not work. May be I did not ask my problem properly so let me explain it again.

I am building some Excel Application in which I am creating some Menus as well as some toolbars. For this purpose I have written different subroutines for creating and detroying Menus and Toolbars. For creating them I am calling these subroutines in my Auto_Open and to detroy them I am destroying them in Auto_Close. My problem is If I have any other workbook opened along with my Macro Workbook or if I open another one, the menus gets created for that workbook.

Now as you said that I should place that code in Workbook_BeforeClose event, it would not work because that code will fire only if I close that workbook and it will complain that 'Can not execute in break mode'.

I want these menus and toolbars to be restricted for Macro Workbook only.

Regards,
Gajendra Gupta