How can I make excel open every time at 200%?

[barrfly]

Paste this into a VBA module in your personal VBA folder. Go there by
selecting tools -> Macro -> Visual Basic Editor. Then Insert a module
in the modules folder.

The name of this subroutine "autoopen" is unique in that it runs every
time a workbook is opened.


Sub autoopen()
ActiveWindow.Zoom = 200
End Sub

 

[Dave Peterson]

I think you meant:

sub Auto_open()

(with the underscore)