Autozoom in excel 2003?

[vibutx]

Hi,

Everytime i open up excel the zoom is at 100%. Is it possible to have the zoom say for example at 80 percent every time i open a file?

Thanks!

[Andy Pope]

You would need code to change the zoom on opening workbook.
In order to do this for all workbooks you will need an addin that captures application events.

[vibutx]

Andy,

Thank for your help, but I am very new to excel so I really have no idea what you said . Please explain. Thanks!

[mdbct]

You could assign the following macro to a button and run it when you want to change the zoom on all sheets to 80%

Please Login or Register  to view this content.