ActiveSheet Command not working in Excel Add-In

[BrianExcel]

I am using an add-in with saved subs to run code. The subs are being run from the ribbon. When i try the following code:

MsgBox ThisWorkbook.ActiveSheet

I get an error: "Run-Time error 91. Object variable or with block variable not set."

I have the 'control as iRibbonControl' correctly inserted to call the ribbon.

Why won't this work?

(FYI, even though I add new worksheets via the previous sub (which all works fine), the worksheets don't actually appear in the workbook. It just shows "sheet1" and "thisworkbook" with no additional sheets....

 

[sericom]

Try

MsgBox ThisWorkbook.ActiveSheet.Name

 

[Fazza]

This is the crux of it: The file with the code is the add-in, hence ThisWorkbook is the add-in file.

Maybe you want ActiveWorkbook instead? Or a particular, open (not add-in) workbook.

The error is because ThisWorkbook is the add-in file, and it won't have an ActiveSheet.
Adding sheets to ThisWorkbook won't appear because the add-in isn't visible - look in the VBE (Visual Basic Editor) and you should see the added sheets in the add-in file: they have been added there, not to the open workbook to which you want to add them.