Losing a custom menu bar within Windows menu bar when new excel session is opened.

Hi Team,

I have a few different Custom Menus that I have created for various macro functions in various workbooks. Whenever I restart the computer and launch excel, sometimes one of the menus is still there and the others have dropped off. So I am having to re-create these menus over and again. Which is painful as one of the menus has more than 20 different macro functions.

Is there a simple function or a macro that I would need to keep the menus from disappearing?

Thanks in advance.
Steve

Here's how I have done it. Place the following in the ThisWorkbook code module of the workbook where the specific menu item(s) is/are needed. They will then appear when you are in that workbook, and go away when you leave it. Substitute the menu names, items, and subroutine names with your own.

Please Login or Register  to view this content.

If you have code already in that workbook that opens or activates other workbooks, then additional measures may be needed to avoid triggering this code while that is happening. It's not essential, but it might be desirable, especially if you work in the debugger much.

Probably because you don't have the subroutines defined that it's trying to assign.

Oh, my mistake. Please revise the top line as follows:

Please Login or Register  to view this content.

Yup. Replace Item11Subroutine with your name, etc.

Excellent, this works brilliantly. One last question. Can I add Sub menus inside the main menu that have subroutines attached therein. For instance a Sub menu, might be called "KITS" and the subroutines therein would be called "QPH01KIT", "QPH02KIT" and so on?

I have attached a picture file, as you can see this is how my current menu looks, as you can see it has 2 x Sub Menus then the Macro links to run the Kits. Just wondering if this can be coded?

Sub Menu Lists.png

Thanks again,
Steve

Hi There again, I'm not sure if the attachment has come through on the previous message as it shows up as failed on this end? So have uploaded it again now using advanced options, in the hope it comes through.

I have created macro menu lists for all my various macros now, but if there is a way to create sub menus, so I can keep it all in one menu I would really appreciate knowing the VB code for it.

Thanks in advance...

I can't ever see attached images, so I don't know if that's your problem or mine. Here's the full code, with a submenu added and one item under it.

Please Login or Register  to view this content.