ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   excel 97 crash (https://www.excelbanter.com/excel-programming/290170-excel-97-crash.html)

sashi

excel 97 crash
 
Hi
I am trying to handle WorkbookBeforeClose event to close a
workbook, the sample code looks like below

Private Sub App_WorkbookBeforeClose(ByVal Wb As
Excel.Workbook, Cancel As Boolean)
App.EnableEvents = False
Wb.Close savechanges:=False
App.EnableEvents = True
End Sub

steps to crash
1. create a workbook with the above code
2. select enable macros option when prompted
3. create a new work book and type something
4. close new workbook
5. select No when prompted to save changes
6. try to scroll the workbook
Excel97 crashes
it will be very helpful if anybody can throw some light on
this. thanks


All times are GMT +1. The time now is 09:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com