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


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Joe 90" (remove silly spam) wrote in message ...
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

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.

--
sb
"Joe 90" (remove silly spam) wrote in message
...
Ron

There is that way, but I want users to concentrate on data entry on a
form,
and not be too distracted by other activity on screen. The aim is to
create
what "looks like" a standalone app, even though it is really Excel?

Joe

"Ron de Bruin" wrote in message
...
Why don't you maximize Excel and the Workbook

Application.WindowState = xlMaximized
ActiveWindow.WindowState = xlMaximized


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Joe 90" (remove silly spam) wrote in message
...
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

Ahh you mean a Userform

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Joe 90" (remove silly spam) wrote in message ...
Ron

There is that way, but I want users to concentrate on data entry on a form,
and not be too distracted by other activity on screen. The aim is to create
what "looks like" a standalone app, even though it is really Excel?

Joe

"Ron de Bruin" wrote in message
...
Why don't you maximize Excel and the Workbook

Application.WindowState = xlMaximized
ActiveWindow.WindowState = xlMaximized


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Joe 90" (remove silly spam) wrote in message
...
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

Joe,

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

It works great in one of my projects...

--
sb
"Joe 90" (remove silly spam) wrote in message
...
Very nice :)

"steve" wrote in message
...
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.

--
sb
"Joe 90" (remove silly spam) wrote in message
...
Ron

There is that way, but I want users to concentrate on data entry on a
form,
and not be too distracted by other activity on screen. The aim is to
create
what "looks like" a standalone app, even though it is really Excel?

Joe

"Ron de Bruin" wrote in message
...
Why don't you maximize Excel and the Workbook

Application.WindowState = xlMaximized
ActiveWindow.WindowState = xlMaximized


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Joe 90" (remove silly spam) wrote in message
...
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