Minimize and Maximize

jcg

Board Regular
Joined
Jul 12, 2002
Messages
156
Is there a way to minimize a workbook in VBA and same question for restore once minimized?
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
Application.WindowState = xlMaximized
- or -
Application.WindowState = xlMinimized
 

jcg

Board Regular
Joined
Jul 12, 2002
Messages
156
I should have been more clear, I don't want to minimize the application (excel) just the workbook inside the application. So, is there a way using VBA to minimize (and then maximize) a workbook within excel without minimizing the application itself?

Thanks
 

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
Would this be what you are after?
Code:
    ActiveWindow.WindowState = xlMinimized
'- or - 
    ActiveWindow.WindowState = xlMaximized
 

Watch MrExcel Video

Forum statistics

Threads
1,113,795
Messages
5,544,332
Members
410,603
Latest member
rseckler
Top