You can always to

Application.ScreenUpdating = False
' sample code provided to save the file
application.ScreenUpdating = True

and you will not see the sheet pop up.

--
Regards,
Tom Ogilvy

"groutch" wrote in message
om...
That did it - thanks Tom - Although it's a bit ugly to have a new
sheet pop up just to do this ?

Don Guillett's proposed solution leaves the workbook renamed as
aa1.csv, just as my attempt did, so is not a solution.

Thanks,

Richard