Hide (visible=false) all open applications?

  • Thread starter Thread starter Joe 90
  • Start date Start date
J

Joe 90

Is there a way with code to make all open applications on the desktop either
hide or minimise? (From within Excel/VBA)

I can do it with the VB Editor, and using an If routine with GetObject can
do it with Word, but the same code won't work with Powerpoint.

I just want a clear desktop so that the user can see and work on the form.

Any help much appreciated

Joe
 
Why don't you maximize Excel and the Workbook

Application.WindowState = xlMaximized
ActiveWindow.WindowState = xlMaximized
 
Joe,

Put this in the form initialize event and the form will fill the screen

With Application
Me.Top = .Top
Me.Left = .Left
Me.Height = .Height
Me.Width = .Width
End With


Wrap all of your code with

Sub MySub()
Application.ScreenUpDating = False
* your code *
Application.ScreenUpDating = True
End Sub

to speed up your code and prevent any screen flicker.
 
Joe,

Yep! Just another tid-bit 'stolen' from this forum.

It works great in one of my projects...
 
Back
Top