Maximising Application

  • Thread starter Thread starter ZAK
  • Start date Start date
Z

ZAK

Hi

Is there a way to test if the application is minimised and
if so can it be maximised and made the current or active
application on the window.

Regards

ZAK
 
Zak,

Try the following

AppActivate Application.Caption
Application.WindowState = xlMaximized


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Maximise Event 2
Application Maximise event 1
Maximise Box 5
Minimise worksheets 6
Excel 2003 (8316.8221) screen corruption 8
Maximise and Minimise buttons 6
Excel Window 1
Setting windows of applications to open minimised 2

Back
Top