Maximising Application
 

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

Maximising Application
 

Zak,

Try the following

AppActivate Application.Caption
Application.WindowState = xlMaximized


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"ZAK" wrote in message
...
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