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:
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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html