Can anyone please tell me how I get all worksheets in a workbook to open with a set zoom so that I can see all the information on one screen without scrolling.

thanks

David