Re: $$Excel-Macros$$ Workbook Save Event

2010-10-13 Thread Paul Schreiner
ROS > Sent: Tue, October 12, 2010 5:31:03 PM > Subject: $$Excel-Macros$$ Workbook Save Event > > I have these three subs in the ThisWorkbook code block: > > Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As > Boolean) >     MsgBox ("BeforeSave&q

$$Excel-Macros$$ Workbook Save Event

2010-10-12 Thread TheGrouper
I have these three subs in the ThisWorkbook code block: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) MsgBox ("BeforeSave") End Sub Private Sub Workbook_Save(ByVal SaveUI As Boolean, Cancel As Boolean) Call Workbook_SaveAs(SaveUI, Cancel) End Sub Private S