View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dean Meyer Dean Meyer is offline
external usenet poster
 
Posts: 13
Default It takes two clicks to shut down Excel

Thanks for trying to help, Jim.

"Cancel" is not a defined parameter of Workbook_WindowDeactivate so I
can't add it there.

I loaded Excel fresh, started with a blank workbook and typed the
following into the VB ThisWorkbook object:

Sub Workbook_WindowDeactivate(ByVal Wn As Window)
End Sub

Then I opened any other Excel workbook, made some edit to force a save,
and clicked the big red X.

The problem occured!


Jim Cone wrote:
Add "Cancel = True" to your code.
--
Jim Cone