software

Is there a way to copy a custom view to another worksheet, or to copy it with
the worksheet when you do a Move or Copy worksheet? I have set up special
views and want to copy the worksheet and have the custom view go with it, but
when I copy the worksheet and show the custom view, it takes me back to the
original worksheet. Thanks. Dana

A custom view applies to the workbook, not the worksheet.

If you want the same settings on a different worksheet, create another
custom view, using that worksheet.

Dana wrote:
gt; Is there a way to copy a custom view to another worksheet, or to copy it with
gt; the worksheet when you do a Move or Copy worksheet? I have set up special
gt; views and want to copy the worksheet and have the custom view go with it, but
gt; when I copy the worksheet and show the custom view, it takes me back to the
gt; original worksheet. Thanks. Dana--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html