Hi, I think you need the following code in your button. I'm not totally clear as to any knock-on effects on other open Excel files though.
MD
Application.EnableEvents = False
ActiveWorkbook.Close



I hate it when my computer does what I tell it to, and not what I want it to.