modify the menu bar

[maacmaac]

I have some code that loads and unloads a command under the "DATA" menu bar.

Is it possible to add an item to the menu bar and put the commands under the new menu item?

For example:

Add "XYZ Consulting" as a menu bar item so it would like as follows:

File, Edit, Insert, Format, Tools, Data, Window, XYZ Consulting, Help.

Please Login or Register  to view this content.

[dominicb]

Good evening maacmaac

this should get you started, creating your own menu item and two sub items below it :

Please Login or Register  to view this content.

HTH

DominicB

[maacmaac]

That works great. It so much cleaner doing it this was as before I was putting button bars on other sheets and assigning macros to those. Just a couple of questions (1) what is the find control ID 30010? Where do I find a list of numbers if such a list exists? (2) you have .FaceId = 123 as comment. Why is this a comment and if it was not a comment, what would this part of the code do? Thanks

Please Login or Register  to view this content.

[maacmaac]

I just found the code to identify the face ID codes. Found the code from "The Spreadsheet Page". The link is http://spreadsheetpage.com/index.php...andbar_images/

I would still like more information on FindControl ID if anyone has it. Thanks.

[dominicb]

Hi maacmaac

I would still like more information on FindControl ID if anyone has it. Thanks.

Some menu items in Excel have little icons next to the (for example File > Save has a little old fashined floppy disc image). the FaceID allows you to add a little image to your menu from the set of several thousand provided with Excel.

More is explained here :
http://spreadsheetpage.com/index.php...andbar_images/

You can download a FacieID browser from here :
http://skp.mvps.org/faceid.htm

Why did I comment it out? 'Cos it was late, and I couldn't be bothered looking for a suitable image (not all numbers have an image assigned, so it could have been blank) - I just left it in to show it was ine if the options that can be used in this sort of code.

HTH

DominicB

[maacmaac]

DominicB,

Thanks for all the information. This is very helpful.