[Gene]

I am trying to copy from one workbook to another workbook and keep the column
widths, print settings, etc the same but when I copy using different
functions in paste special nothing changes in the new workbook except the
visual data is present.

The functions of paste special are not grayed out but nothing happens when I
use them.

I am using MS office XP pro, excel 2002, SP3.

Any help is appreciated. I searched the knowledge base and the previous
answers didn't work. For example right clicking the tab and selecting copy
then automatically opens a new workbook with the worksheet but I need to put
the worksheet in an existing workbook. If I select column widths in the
original worksheet when I paste to another workbook the columns are not like
the original.
Thanks
--
Gene