Minimize within Application

jcg

Board Regular
Joined
Jul 12, 2002
Messages
156
Is there a way using VBA to minimize (and then maximize) a workbook within excel without minimizing the application itself?

Thanks
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Good afternoon jcg

How about :

Code:
ActiveWindow.WindowState = xlMinimized
ActiveWindow.WindowState = xlMaximized

HTH

DominicB
 

Watch MrExcel Video

Forum statistics

Threads
1,111,910
Messages
5,541,538
Members
410,547
Latest member
htran4
Top