Menu creation - from DLL rather than .XLA
I have grown fond of Walkenbach's menu-creation code, which basically
reads a bunch of columns off of a worksheet and creates a menu on the
menubar. However, if i were to move this add-in of mine from a .xla
file to a full .dll file, how would I create my menus? Is there any
method of similar convenience to Walkenbach's method?
Would it be possible to store the entire structure in the Registry, and
have a custom class that can read a given Registry path create the menu
instead?
Or is there another way I overlook? I would most appreciate any help!
Thanks.
|