OK, thank you.


"JE McGimpsey" wrote in message
...
That's your responsibility in writing the add-in. Make sure the
reference is fully qualified. For example:

Public Sub CopySheet1()
ThisWorkbook.Sheets("Test1").Copy
'...
End Sub


In article ,
"Eric" wrote:

It works!! My question now is why? How does it know that sheet1 is the
one
in my Add-in and not the one in the current workbook for instance?