Sory David, May be i was not so clear. Actually I have serveral worsheets on
a workbook with formulea referencing to one master worksheet on the same
workbook. I want to select several worksheets and copy them to a new workbook
but with values and formats on as my coleagues need not see the formula. I
tried paste special but its a bit time consuming as the all the print
settings and pictures do not come right!
The best thing is just to select multiple sheets and copy to other workbook
by a right click, which keeps everything intact. But the problem is that i
cannot get rid of the fomulea :-(
thanks.