No screen updating in Workbook_BeforeSave event after ActiveWorkbook.Save
 

Hello,

I'm currently struggling with a strange problem. When I execute th
ActiveWorkbook.Save method from within VBA the BeforeSave event i
fired. In the Workbook_BeforeSave eventhandler I do my stuff, bu
strangely enough I cannot see what is happening in my Excel screen. Fo
instance if I select another sheet or select another cell the screen i
not updated. Only value assignments to cells are shown. This gives me
hard time to debug my code in the Workbook_BeforeSave eventhandler. Th
EnableEvents and ScreenUpdating properties are both set to true. Thi
problem does not occur when I enter the Workbook_BeforeSav
eventhandler via Excel's Save button.

I use Excel 2002, but this problem also occurs in Excel 97.

Does anybody know a solution/workaround?

Boudewij

--
bmeijer
-----------------------------------------------------------------------
bmeijers's Profile: http://www.excelforum.com/member.php...fo&userid=2917
View this thread: http://www.excelforum.com/showthread.php?threadid=48905