I'm trying to refer to a worksheet from an Add-In in a workbook open event. The Add-In has the code.
I've learnt that ThisWorkbook relates to the Add-In and ActiveWorkbook refers to the workbook you are working on.
When I test though: The first line works and goes the name of the sheet in the Add-In.
The second part gives an error message.
Why?
Please Login or Register to view this content.
Can you attach your Excel test file.
See mine attach, there is no issues it seems, always the same result: Sheet"s name
- Battle without fear gives no glory - Just try
Yes I have tried yours. It also has the same issue.
Save the Add-In and load it into Excel.
Then open a blank workbook and you'll get the error message.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks