add a line:
sheets("Sheet1").visible = False

"nickm687" wrote in message
ps.com:

Hi Ron,

Your code works perfectly, thank you.

May i ask how would you, using the above code, hide one of the
workseets (e.g. sheet1) in the copy book?

Regards
Nick