Thanks Peter, but looking at the code, I don't think it can possibly work as every line in it must execute before printing starts. So sheets are hidden then displayed, and so all the sheets will print.