View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dean Meyer Dean Meyer is offline
external usenet poster
 
Posts: 13
Default Workbook.Save triggers event Workbook_BeforeSave and things don't work!

I catch the event Workbook_BeforeSave and do a number of things, and
that works fine.

But when a VB subroutine calls Workbook.Save or Workbook.SaveAs, which
of course triggers the Workbook_BeforeSave event, a number of things in
the BeforeSave sub just don't work. The list includes:
* Worksheet.Unprotect / Worksheet.Protect
'*Application.Iteration = True/False
'*Application.ScreenUpdating = True/False
'*Application.Goto / Range.Select
'*Application.StatusBar = ...

Does anybody have any clues as to why? How about a work-around?

(Excel 2003)