Dummy post so I can creat4e an attachement

[lovespar]

no response required

[Bob Phillips]

Do them all in the original thread mate.

[lovespar]

Thanks for looking at this, it is working now, I don't know why. I did take the message box off of the code, I have been struggling with different ways to do this for a week.

Public Sub SaveAndClose()
MsgBox "saved and Closing...."
ThisWorkbook.Close savechanges:=True
End Sub