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

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

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,118,709
Messages
5,573,735
Members
412,550
Latest member
soking
Top