Window sizes

R

Rick

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?
 
G

Gary''s Student

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.
 
Top