Results 1 to 5 of 5

Thread: iRibbonControl (show a worksheet)

  1. #1

    iRibbonControl (show a worksheet)



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Why not just copy it to a new workbook?

  3. #3
    @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.


    Quote Originally Posted by Bob Phillips View Post
    Why not just copy it to a new workbook?

  4. #4
    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.

  5. #5
    Quote Originally Posted by Bob Phillips View Post
    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.
    alright then. I will try other ways to work it out . Many thanks Bob

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •