Looking for an event

[Jan Kronsell]

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

 

[Bob Phillips]

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

 

[Jan Kronsell]

Thats what I thought. To bad.

Thanks anyway.

Jan

 

[David McRitchie]

What exactly do you want to do. There may be other
solutions. I can convert a selection of cells to HTML
code and invoke a web browser, and could if I wanted
to exit out of Excel.