Consulting

Results 1 to 2 of 2

Thread: Workbook_BeforeClose and Workbook_Deactivate

  1. #1
    VBAX Mentor
    Joined
    Nov 2008
    Posts
    305
    Location

    Workbook_BeforeClose and Workbook_Deactivate

    Is there a reason why
    Workbook_BeforeClose, and Workbook_Deactivate functions wouldn't be activated when a user closes a workbook?

    Would an Application.EnableEvents = False have an effect?


    Edit: Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range), which is also in the ThisWorkbook code isn't working.
    Last edited by ukdane; 01-20-2009 at 12:53 AM.

  2. #2
    VBAX Mentor
    Joined
    Nov 2008
    Posts
    305
    Location
    Just tried changing the Application.EnableEvents = False code to TRUE, and it seems it does have an effect.

Posting Permissions

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