Opposite of Auto_Open
Paul, here it is
Private Sub Workbook_BeforeClose(Cancel As Boolean)
'your code here
End Sub
--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"Paul Moles" wrote in message
...
What is the opposite of Auto_Open ie a macro that runs as
a workbook closes.?
Many Thanks
Paul Moles
|