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