executing tasks prior to saving
 

Actually, there is a "BeforeSave" event. Paste the following code into
the ThisWorkbook object in the VBE:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)

End Sub

Or, just click workbook from the drop down and then BeforeSave.

Let me know if that doesn't work.

Mark

---
Mark Bigelow
mjbigelow at hotmail dot com
http://hm.imperialoiltx.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!