1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Trigger Worksheet Activate event from within AddIn

Discussion in 'VBA Macros' started by rolo, Jun 17, 2017.

  1. rolo

    rolo New Member

    Messages:
    23
    Hello,

    I´ve been able to trigger a workbook event from within addin using this example:
    http://www.cpearson.com/excel/AppEvent.aspx

    But now I need some help on how to trigger a Worksheet Activate event from within addin

    Thanks!
  2. YasserKhalil

    YasserKhalil Active Member

    Messages:
    576
    Hello
    Have a look at this sample .. May be help you out

    Attached Files:

  3. rolo

    rolo New Member

    Messages:
    23
    Sorry, it does not work for me...

    Don´t you need to add a class module?
  4. Debaser

    Debaser Active Member

    Messages:
    334
    Is it for one specific sheet?

    There is a workbook and/or application level SheetActivate event that you might use (simply test if the Sh argument is the sheet you are interested in), or you might use a Worksheet variable declared WithEvents.

Share This Page