software

How do you copy a complete worksheet and when its pasted into a new workbook
all the referances, macro, print setup go along with it. When I do a copy a
worksheet to another workbook the graphs (source) still points to the
original file.

Thanks,

Paul H

It sounds like you want to make a copy of the sheet. Use Edit, move or copy
sheet. Then check make a copy and select where you want it (new book or
other open workbook)

quot;Paul Hquot; wrote:

gt; How do you copy a complete worksheet and when its pasted into a new workbook
gt; all the referances, macro, print setup go along with it. When I do a copy a
gt; worksheet to another workbook the graphs (source) still points to the
gt; original file.
gt;
gt; Thanks,
gt;
gt; Paul H