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

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

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,812
Messages
5,574,470
Members
412,595
Latest member
slim313
Top