Thread: Worksheet.Unprotect within WorkbookBeforeSave event fails if Save initiated by VB
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dean Meyer[_2_] Dean Meyer[_2_] is offline
external usenet poster
  
Posts: 12
Default Worksheet.Unprotect within WorkbookBeforeSave event fails if Save
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