#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 334
Default Window sizes

I need to open several instsnces of Excell at the same time. They need to be
of different sizes. can this be done with a pre-set parameter rather thn
resizing each window each and every time?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default Window sizes

You can re-size either the application or an individual Excel window in a
workbook open event macro with commands like:

Application.Top=10
or Application.Height

Just read the values after you have re-sized them manually and include the
correct re-sizing the the macro.

--
Gary''s Student - gsnu200775


"Rick" wrote:

I need to open several instsnces of Excell at the same time. They need to be
of different sizes. can this be done with a pre-set parameter rather thn
resizing each window each and every time?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to save a desired window size but hv window comeup fullsz by d smjm1982 Excel Discussion (Misc queries) 1 February 15th 08 11:10 AM
View cell contents as a pop-up window (similar to comments window) Oldersox Excel Worksheet Functions 1 February 6th 08 07:09 AM
Docking Project Explorer, Properties window and Code window in VBE jayray Setting up and Configuration of Excel 2 March 27th 07 04:42 PM
Chart sizes with window in Excel 2007? Mosheo Charts and Charting in Excel 2 January 9th 07 02:46 AM
The window opens in a smaller window not full sized window. Rachael Excel Discussion (Misc queries) 0 November 7th 06 09:04 PM


All times are GMT +1. The time now is 01:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"