Add In Files with a hidden worksheet

[Kdilas]

Recently my company moved from Excel 2003 to Excel 2007 and as a result I had to Rewrite most of my macros. At that time i took the oppertunity to save my file as an add in which made everything look very professional. My problem is I had a hidden worksheet in the file which i used for various calculations. Now that the file is an addin i can no longer edit the hidden worksheet. Does anyone know how I can get to a place to edit that hidden worksheet??

 

[Andrew Poulsom]

Open the Add-In and in the Visual Basic Editor set the IsAddin property of ThisWorkbook to False.

 

[Kdilas]

Thank You Andrew, It appears I now have access to my Hidden worksheet...