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