Copy a worksheet, including the "view"

[Kade]

Hi
I have a workbook with many sheets, one sheet per dog breed.
I have a "template sheet" (sheet 1)which I use to copy from when I need another sheet (for another breed)
Each sheet has two print macros for two different parts of the active sheet. The macros called up "named" ranges.

I thought it would be easier to create "views" which would include all my print settings and simplify the macro

I altered the "template" sheet and it work grand,
However when I copied it to create a new sheet for another breed the macro returned to the master Template sheet where the view was created.

Can I make the "view" relative to the active worksheet.
or is there another solution?

hhmmmmm sorry if it is a bit wordy
thanks kade

 

[jimboy]

Kade,

You will have to record a macro to do this for you.

jimboy.