Open and View xlam Add-in files

[ptmuldoon]

Maybe I'm just not thinking straight this morning. But how do you view the actual worksheets in an Addin-File?

I'm trying to add a Table into a worksheet of the Addin that will be used to populate a listbox in one of the Add-in macros/usersforms.

I have removed the xlam add-in from my Excel Start Folder. I then Launch Excel, open the xlam file, and can view and edit the VBA code in the Add-in when pressing Alt-F11.

But I can't seem to actually see any worksheets in the addin?

EDIT. Took a few searches. But i finally found it here

http://www.excelforum.com/excel-gene...xlam-file.html

1. Make sure project explorer and properties windows are both visible in VBA
2. Select thisworkbook from project explorer, and set IsAddin property to false.

This will make worksheets visible. Make your changes to the worksheets and reset the isaddin property to true.