ukdane
01-20-2009, 12:40 AM
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.
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.