Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a workbook with a specified size?
Hello everyone,
Is there a way to program a workbook to always open in a specific window size? Thanks for any help, ~Jonathan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a workbook with a specified size?
To code something to happen when you open a workbook, take a look at
Workbook_Open in the VBA help OR See the various 'Open Events' at Chip Pearson's site: http://www.cpearson.com/excel/events.htm As far as the sizing of the window: Application.WindowState = xlNormal Application.Width = 717 Application.Height = 487.5 HTH--Lonnie M. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a workbook with a specified size?
See below: but if you want to ensure that the window size (actual inches) is
consistent regardless of the user's display properties (screen resolution) that is a much more difficult question. Private Sub Workbook_Open() Application.WindowState = xlNormal Application.Width = 500 Application.Height = 300 End Sub "42" wrote: Hello everyone, Is there a way to program a workbook to always open in a specific window size? Thanks for any help, ~Jonathan |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a workbook with a specified size?
Thanks, K Dales. That's exactly what I'm looking for. How do I go about
ensuring a user of the network will open the workbook at a specified resolution. Does the solution you offered do that? ~Jonathan *** Sent via Developersdex http://www.developersdex.com *** |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a workbook with a specified size?
Thanks, Lonnie. I appreciate your swift reply.
~Jonathan Ps: I'll let you guys know if it works over the network ;) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop blank workbook from opening when opening an existing | Excel Discussion (Misc queries) | |||
can i size an Excel workbook window's opening size? | Excel Discussion (Misc queries) | |||
excel VBA problem - setting workbook as variable & opening/re-opening | Excel Programming | |||
How to make the opening of a workbook conditional upon the opening of another workbook | Excel Programming | |||
How to make opening of workbook conditional of opening of another workbook | Excel Programming |