no response required
no response required
Do them all in the original thread mate.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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