Menus

[mcdude]

Howdy:

I upgraded to Excel 2000 a few months ago and it is going OK...

..but... I would like to open a Workbook with it's own code that runs off it's own MENU item. I used to be able to do this in Excel 5 with Autpen macro's but I'll be goshdurned if I can do it in Excel 2000...

..I have a workbook I use maybe once a year that has a large amount of code run by a large amount of macro's and it seems to me the sensible thing to do is to load a MENU with the workbook.

I am creating the menu's OK.. I just don't want them there when I don't need them.

Thanks in advance

 

[TommyGun]

The old Auto-Open/Auto-Close macros have been replaced in Excel 2000. You will need to use the Workbook_Open/Workbook_BeforeClose events. The code for these are placed in the Workbook object module. If you have problems, search the VBA help file for Event handlers.

 

[mcdude]

Thnx Tommy.

I am wondering what event I am going to handle tho' as I can name a Toolbar ok but I don't see anything anywhere about naming a MENU

 

[TommyGun]

Check out this link and see if it helps. If not search the board for menus, and you should return a lot of hits.

http://www.cpearson.com/excel/menus.htm

 

[mcdude]

Bingo. That link should do it. I think I'll code it up and create the Menu Items all off a single menu item and just delete them all when I 've finished using it. Many thanks.