View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
faffo1980 faffo1980 is offline
external usenet poster
 
Posts: 22
Default WorkBook Deactivate Event

Hi all,
The workbook Deactivate event is called when the active workbook is changed
and when the workbook is closed.
The event BeforeClosed for a workbook is called before the event Deactivate.

Is there a way to determine if the WB deactivation is caused by a Close
operation or a change operation?

Thanks

faffo1980