| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I make excel open every time at 200%?
|
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make a time Stamp in excel? | Excel Discussion (Misc queries) | |||
| Open excel files | Excel Discussion (Misc queries) | |||
| When I open excel document it always ask if I want to open it in . | Excel Discussion (Misc queries) | |||
| make an excel worksheet (sheet 2) open w/ the cursor located in t. | Excel Discussion (Misc queries) | |||
| Excel Files Won't Open From Shortcut | Excel Discussion (Misc queries) | |||
Linear Mode
