Hi FunkymonkUK

Whether here is fine and sunny, quite warm. Had a heavy downpour abou
half an hour ago but it's drying nicely now, but not like the scorcher
we had on Sunday and Monday.

Anyway, the code to do this is fairly simple:

ActiveWorkbook.PrintOut

Seems a bit too easy, but just had a play with it and it seems to wor
OK. BTW, check your private messages.

HTH

Dominic

--
dominic
-----------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=38348