Minimize and Maximize

[jcg]

Is there a way to minimize a workbook in VBA and same question for restore once minimized?

 

[Datsmart]

Application.WindowState = xlMaximized
- or -
Application.WindowState = xlMinimized

 

[jcg]

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]

Would this be what you are after?

    ActiveWindow.WindowState = xlMinimized
'- or - 
    ActiveWindow.WindowState = xlMaximized