how to copy only values and formats of worksheets to new workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi zer,
I need to copy worksheets to new workbooks (only values and formats) but
without any cell reference to the original workbook.
 
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.
 
Back
Top