Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
ZAK ZAK is offline
external usenet poster
 
Posts: 6
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA-Application Gaurav Jindal Excel Discussion (Misc queries) 2 November 20th 06 09:50 AM
Application Look Daniell Excel Discussion (Misc queries) 0 September 26th 05 10:48 PM
Profit maximising mark_b2410 Excel Worksheet Functions 4 November 25th 04 11:44 PM
Getting Application.Sum to act like =SUM Mike Cooper Excel Programming 0 July 21st 03 10:26 PM
What's this? (Application.Run) Karl Thompson Excel Programming 1 July 10th 03 07:46 PM


All times are GMT +1. The time now is 04:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"