-
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.
-
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
-
Forum Rules