View Single Post
  #2   Report Post  
barrfly
 
Posts: n/a
Default


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