Why the file crash in excel 2013

[zhouyi]

I had run the following simple code in excel 2003 well, but when I open the file in excel2013, excel may crash. please give me ideas

Private Sub WorkSheet_BeforeDoubleClick(ByVal target As Range, CANCEL As Boolean)
ActiveWorkbook.Close
End Sub

the following rus well both in excel2003 and 2013
sub test()
ActiveWorkbook.Close
End Sub

with my regards.

 

[Andrew Poulsom]

Welcome to MrExcel.

I confirm that your code causes a crash in Excel 2007, 2010 and 2013, but not in 2003. Sorry, I don't know why.

 

[Peter_SSs]

Welcome to the MrExcel board!

I believe that it is a known bug (but nothing has been done about it).

A workaround is to put your working "test" sub in a standard module an then use this in your double-click event code

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
  Cancel = True
  Application.OnTime Now, "test"
End Sub