ExcelBanter - Custom Views

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Custom Views (https://www.excelbanter.com/excel-worksheet-functions/75512-custom-views.html)

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