After you open wb2 you can add this

wb2.Sheets("Sheet1").Visible = False

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"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