none
Workbook_Deactivate will not fire RRS feed

  • Question

  • Private Sub Workbook_Deactivate()

    MenuBars(xlWorksheet).Reset

    End Sub

    It will not fire when I close out of excel and I am not sure why?

    • Moved by 许阳(无锡)Moderator Thursday, October 4, 2012 8:01 AM VBA Issue (From:Developing Apps for Office 2013)
    Monday, September 24, 2012 10:03 PM

All replies

  • Hi Steven,

    Thanks for posting in the MSDN Forum.

    Would you please clarify your issue more clearly? It's based on my experience that your issue is an Excel VBA issue, it has no relationship with Apps development. And if it is Excel for developers forum will make more sense. And how you are able to prove that Workbook_Deactivate will not fire when workbook close.

    Have a good day,

    Tom


    Tom Xu [MSFT]
    MSDN Community Support | Feedback to us

    Tuesday, September 25, 2012 1:47 AM
    Moderator