PDA

View Full Version : Dummy post so I can creat4e an attachement



lovespar
07-23-2007, 10:24 AM
no response required

Bob Phillips
07-23-2007, 10:28 AM
Do them all in the original thread mate.

lovespar
07-23-2007, 10:33 AM
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