Hello,
I'm currently struggling with a strange problem. When I execute the ActiveWorkbook.Save method from within VBA the BeforeSave event is fired. In the Workbook_BeforeSave eventhandler I do my stuff, but strangely enough I cannot see what is happening in my Excel screen. For instance if I select another sheet or select another cell the screen is not updated. Only value assignments to cells are shown. This gives me a hard time to debug my code in the Workbook_BeforeSave eventhandler. The EnableEvents and ScreenUpdating properties are both set to true. This problem does not occur when I enter the Workbook_BeforeSave eventhandler via Excel's Save button.
I use Excel 2002, but this problem also occurs in Excel 97.
Does anybody know a solution/workaround?
Boudewijn
I'm currently struggling with a strange problem. When I execute the ActiveWorkbook.Save method from within VBA the BeforeSave event is fired. In the Workbook_BeforeSave eventhandler I do my stuff, but strangely enough I cannot see what is happening in my Excel screen. For instance if I select another sheet or select another cell the screen is not updated. Only value assignments to cells are shown. This gives me a hard time to debug my code in the Workbook_BeforeSave eventhandler. The EnableEvents and ScreenUpdating properties are both set to true. This problem does not occur when I enter the Workbook_BeforeSave eventhandler via Excel's Save button.
I use Excel 2002, but this problem also occurs in Excel 97.
Does anybody know a solution/workaround?
Boudewijn