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

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


--
barrfly

Excel User - Energy markets
------------------------------------------------------------------------
barrfly's Profile: http://www.excelforum.com/member.php...fo&userid=4141
View this thread: http://www.excelforum.com/showthread...hreadid=391879

I think you meant:

sub Auto_open()

(with the underscore)

barrfly wrote:

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

--
barrfly

Excel User - Energy markets
------------------------------------------------------------------------
barrfly's Profile: http://www.excelforum.com/member.php...fo&userid=4141
View this thread: http://www.excelforum.com/showthread...hreadid=391879

--

Dave Peterson