Edit Sheets in Excel Addin

[Tim879]

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

 

[Bernie Deitrick]

Tim,

Change the IsAddin property of the ThisWorkbook object to False - then you can view it or Unhide it
within Excel.

Just change the property back to True before you save the add-in (through the VBE' file save menu).

HTH,
Bernie
MS Excel MVP

 

[Tim879]

You are amazing.

thank you so much!!!!

Tim,

Change the IsAddin property of the ThisWorkbook object to False - then you can view it or Unhide it
within Excel.

Just change the property back to True before you save the add-in (through the VBE' file save menu).

HTH,
Bernie
MS Excel MVP