![]() |
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 |
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 |
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 |
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