still havent worked out why it keeps re-opening - but the sure fire way
of closing is

Private Sub Workbook_BeforeClose(Cancel As Boolean)
application.quit
End Sub


--
bhawanePosted from http://www.pcreview.co.uk/ newsgroup access