Cascading Menu for Excel Addin in C#

[shantanu]

Dear All
I have a requirement for creating a sub menu. I have been
working on the addin and was able to put the addin in the tools menu
of excel. The menu will be something like:

1. Main Item
1.a. Sub item 1
1.a.i sub item 1
1.a.ii sub item 2
1.b. Sub item 1
1.b.i sub item 1
1.b.ii sub item 2

Can anybody help in creating this kind of menu formation in excel from
C# addin.

Regards
shantanu

 

[Nicholas Paldino [.NET/C# MVP]]

shantanu,

If you have already inserted a menu item into excel, then the rest
should be the same. Using the CommandBar objects, you should be able to add
sub-menus to your menus and so on, and so on.