Or

myss.workbooks(1).close savechanges:=false

And you shouldn't see the prompt.

PeteCresswell wrote:

What am I missing?

Sorry for trashing the NG... I think I found the obvious:

2990 With mySS
2991 .Application.DisplayAlerts = False
2992 .Workbooks(1).Close
2993 .Quit
2994 .Application.DisplayAlerts = True
2999 End With

--

Dave Peterson