Tim, do it like this, put in thisworkbook code

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
'your code here
End Sub

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

"Tim" wrote in message
...
Is it possible to have the workbook save event trigger VB
code to run in Excel? I know you can do it in ACCESS. If
so, how would I do that?

Thanks.