Good morning Mahros

You can do it but have to do so on a sheet by sheet basis. Left click
in the top left hand corner, next to the column headings and just above
the row titles - this will highlight the whole sheet. Right click,
select copy and then paste it into a new workbook.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=385532