View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming, microsoft.public.excel.misc
Tim879 Tim879 is offline
external usenet poster
 
Posts: 208
Default Edit Sheets in Excel Addin

I created an excel addin and used the menumaker code I found in
another post (http://www.andrewsexceltips.com/multi_menu_maker.htm) to
create the menus for the addin.

The menu maker code lets you type the caption / macro name in a "Menu"
worksheet. The code then loops through this sheet and creates your
menus.

I now need to update the menus to add some new macro names and delete
some old ones that I want to remove but I can't figure out how to view
the actual worksheets.

I've tried opening the add-in and also changing the extension in
Windows Explorer to .xls and had no luck. Any suggestions?

Thanks
Tim