Can I set default view and print area?

  • Thread starter Thread starter puter
  • Start date Start date
P

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