Can I set default view and print area?

[puter]

I receive a test report in Excel form. Each report is a workbook
consisting of several worksheets. All worksheets are identical excep
the data.

What I want to do is to set default view on one worksheet and apply i
to all worksheets of the workbook. I also want to repeat the same fo
print area, too. Please help

 

[Bernard Liengme]

I would record a macro and store it in Personal.XLS
best wishes

 

[puter]

Thank you. I will learn macros and do it

 

[puter]

Did my first macro recording. It worked well. But I am still missin
something. I want the macro to affect all the worksheets of th
workbook. But it works on the current worksheet only. When I select th
next worksheet, I have to apply the macro again. Please advise. Thanks

 

[Bernard Liengme]

Try grouping the sheets. Click on Sheet1, hold SHIFT, click on last sheet
Record macro as you do this. Copy the statements from this to you other
subroutine
Isn't learning fun!
Next you need to learn how to add a button to worksheet to run the
subroutine
all the best

 

[puter]

Thank you, thank you, thank you. I have all the tools I need for now