Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Workbook_BeforeSave Event | Excel Programming | |||
No screen updating in Workbook_BeforeSave event after ActiveWorkbook.Save | Excel Programming | |||
Event Triggers | Excel Programming | |||
Problem with Workbook_BeforeSave event | Excel Programming | |||
"Save As" triggers combo_change event | Excel Programming |