Per Dave Peterson:
Or

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

And you shouldn't see the prompt.

Thanks... that cleaned up my code by a few lines.... and maybe
whoever looks at it will actually think I know what I'm doing....
-)
--
PeteCresswell