Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
default settings
How do I configure Excel And Word 2007 so that when they open they do so NOt
to maximised but to the size I like to work with on my screen? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
default settings
You can customize the exact size and shape of an application window. In fact
you can customize this for individual spreadsheets and word documents. The following macro first sets the upper-left hand corner of an Excel window and then sets the height and width: Sub place_it_properly() With Application .WindowState = xlNormal .Top = 10 .Left = 10 .Height = 400 .Width = 600 End With End Sub If you put this type of code in your Workbook_Open routine, it will re-size upon openning. -- Gary''s Student - gsnu200739 "ItsMagic" wrote: How do I configure Excel And Word 2007 so that when they open they do so NOt to maximised but to the size I like to work with on my screen? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default settings for currency | Setting up and Configuration of Excel | |||
pivot default settings | Excel Discussion (Misc queries) | |||
Default Page Settings | Excel Worksheet Functions | |||
hyperlink default settings | Excel Discussion (Misc queries) | |||
Default View Settings | Setting up and Configuration of Excel |