#1. Manually:

hit alt-f11 (to get to the VBE)
hit ctrl-r (to see the project explorer)
click on your project
hit F4 to see its properties
change the isAddin to false

Back to excel and do what you want.
then back to the VBE and change isaddin to true
(don't forget to save your changes)

#2. If the code is in the addin, you can use ThisWorkbook.

activeworkbook.range("a1:a10").value _
= thisworkbook.worksheets("topsecret").range(c1:c10" ).value



ExcelMonkey wrote:

I have some sheets in my add-in file. how can I acces them manually. That
is, you cannot see them when using the file as an Add-in.

Secondly, if I wanted to access data in these sheets, can I simply use the
Thisworkbook Object to do so?

Thanks

--

Dave Peterson