Behind the button that closes the sheet use the following code:
----------------------------------------------
On Error GoTo err1
me.close
err1:
MsgBox err.description
----------------------------------------------
This will attempt to close the worksheet, and if it cant, you will get the description of the error. If you get the description, post it back here.
cheers mate
Maz