Looking for an event
 

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

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

Looking for an event
 

Thats what I thought. To bad.

Thanks anyway.

Jan

"Bob Phillips" skrev i en meddelelse
...
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

Looking for an event
 

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.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Jan Kronsell" wrote in message ...
Thats what I thought. To bad.

Thanks anyway.

Jan

"Bob Phillips" skrev i en meddelelse
...
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