Minimizing applications

[Don Wells]

Is it possible using VBA, to minimize all running applications.

T.I.A.

[HansV]

Yes:

Code: Select all

Sub MinimizeAll()
  CreateObject("Shell.Application").MinimizeAll
End Sub

This will work from any application with VBA (Word, Excel, Acces, ...)

[Don Wells]

Thank you Hans.
    As always; it works a treat.