Hi
I have created an Add-in and would like to bring a "particular" worksheet in focus. But the worksheet is in the add-in bundle where I have all the other controls.
Is it possible to activate an worksheet which is the add-in itself? Any inputs?
Where "PPproject" is a worksheet inside add-in
I have created an Add-in and would like to bring a "particular" worksheet in focus. But the worksheet is in the add-in bundle where I have all the other controls.
Is it possible to activate an worksheet which is the add-in itself? Any inputs?
Code:
Public Sub ShowHome(control As IRibbonControl)
'
' Code for onAction callback. Ribbon control button
Worksheets("PPproject").Visible = True
Worksheets("PPproject").Activate
End Sub
Where "PPproject" is a worksheet inside add-in