View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Looking for an event

Don't think so, there is no event even with application events.

--
HTH

Bob Phillips

"Jan Kronsell" wrote in message
...
Hi NG!

Is there any event that is trigged, when I leave Excel, to go to another
application?

Case: I have Excel open and also fx Word. I like to do something like:

Application.CutCopyMode = False

whenever I leave Excel for another application either by Alt+TYab,

clicling
or by starting a new application.

I tried

Private Sub Workbook_WindowDeactivate(ByVal Wn As Window)
Application.CutCopyMode = False
End Sub

but thst doesn't do the trixk as I am not leaving the workbook window, but
the application window.

Jan