Thread: Worksheet.Unprotect within WorkbookBeforeSave event fails if Save initiated by VB
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dean Meyer Dean Meyer is offline
external usenet poster
  
Posts: 13
Default Worksheet.Unprotect within WorkbookBeforeSave event fails if Save initiated by VB
My current solution: If VB wants to save, calls a procedure that
includes:

Sub FileSave(TargetWorkbook as Workbook)
If Not WorkbookBeforeSave(TargetWorkbook ) Then
Application.EnableEvents = False
TargetWorkbook .Save
Application.EnableEvents = True
End If


Reply With QuoteReply With Quote