PDA

View Full Version : Workbook_BeforeClose and Workbook_Deactivate



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.

ukdane
01-20-2009, 01:04 AM
Just tried changing the Application.EnableEvents = False code to TRUE, and it seems it does have an effect.