iRibbonControl (show a worksheet)

M

Mr.Karr

New member
Joined
Oct 21, 2014
Messages
13
Reaction score
0
Points
0
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?


Please be so kind to respond. I have a trouble to get this to work.

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


Many thanks in advance
 
Why not just copy it to a new workbook?
 
@Bob: This add-in is for distribution. We cannot have the option to copy this to a new workbook because the source file is with the users and it's for 20+ department.

Main functionality what I expect with this add-in is to comfortably sit on top of the ribbon and opens up the home page (where we have the other macro buttons. Please let me know if you need additional information.


Bob Phillips said:
Why not just copy it to a new workbook?
Click to expand...
 
I mean just to show it. When it is needed to bring it into focus, then copy it. If it contains data that the user will update, then it shouldn't be in the addin, period.
 
Bob Phillips said:
I mean just to show it. When it is needed to bring it into focus, then copy it. If it contains data that the user will update, then it shouldn't be in the addin, period.
Click to expand...

alright then. I will try other ways to work it out . Many thanks Bob
 
You must log in or register to reply here.
Back
Top