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!