ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Controlling the Excel application with VBA (https://www.excelbanter.com/excel-programming/346104-controlling-excel-application-vba.html)

Gary''s Student

Controlling the Excel application with VBA
 
I can move and re-size the Excel window using the mouse. Is there an
Application.something_or_other that will allow me to do this with VBA?
--
Gary''s Student

Norman Jones

Controlling the Excel application with VBA
 
Hi Gary's Student,

Look at the Application's Top, Left, Height, Width and WindoState
properties.


---
Regards,
Norman


"Gary''s Student" wrote in message
...
I can move and re-size the Excel window using the mouse. Is there an
Application.something_or_other that will allow me to do this with VBA?
--
Gary''s Student




Norman Jones

Controlling the Excel application with VBA
 

WindoState


== WindowState


---
Regards,
Norman



"Norman Jones" wrote in message
...
Hi Gary's Student,

Look at the Application's Top, Left, Height, Width and WindoState
properties.


---
Regards,
Norman




Gary''s Student

Controlling the Excel application with VBA
 
Thank you Norman. once I set the WindowState to xlnormal, things began to
happen
--
Gary''s Student


"Norman Jones" wrote:


WindoState


== WindowState


---
Regards,
Norman



"Norman Jones" wrote in message
...
Hi Gary's Student,

Look at the Application's Top, Left, Height, Width and WindoState
properties.


---
Regards,
Norman






All times are GMT +1. The time now is 07:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com