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

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" wrote in message
...
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

You are amazing.

thank you so much!!!!


On Nov 28, 11:54 am, "Bernie Deitrick" <deitbe @ consumer dot org
wrote:
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" wrote in message

...

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