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

Edit Sheets in Excel Addin
 

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

Edit Sheets in Excel Addin
 

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