I've got a userform which creates a new file and populates it with various
things. What I'd like to have is that when the userform unloads that the new
file already has the Save As window open to motivate the user to save the
output.

I can't figure out how to just have it pop up but not to feed it any info so
that the sub can end.

Thanks
Paul

application.ActiveWorkbook.SaveAs to achive just that.

"darryl26" wrote:

I've got a userform which creates a new file and populates it with various
things. What I'd like to have is that when the userform unloads that the new
file already has the Save As window open to motivate the user to save the
output.

I can't figure out how to just have it pop up but not to feed it any info so
that the sub can end.

Thanks
Paul