I have been unable to make a copy of a worksheet within a file or by copying
it to a new workbook. When I try copying it to a new file, the new workbook
appears temporarily and then disappears. Any suggestions would be
appreciated.

I am using Excel 2002.