View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
R Avery R Avery is offline
external usenet poster
 
Posts: 220
Default 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.