Hide (visible+AD0-false) all open applications?
 

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 +ACI-looks like+ACI- a standalone app, even though it is really Excel?

Joe

+ACI-Ron de Bruin+ACI- +ADw-rondebruin+AEA-kabelfoon.nl+AD4- wrote in message
news:uvqHFkNmDHA.744+AEA-tk2msftngp13.phx.gbl...
Why don't you maximize Excel and the Workbook

Application.WindowState +AD0- xlMaximized
ActiveWindow.WindowState +AD0- xlMaximized


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



+ACI-Joe 90+ACI- +ADw-joe+AEA-sillyspambimma.me.uk(remove silly spam)+AD4- wrote in message
news:3f96e2a4+ACQ-1+AF8-1+AEA-mk-nntp-2.news.uk.tiscali.com...
+AD4- Is there a way with code to make all open applications on the desktop
either
+AD4- hide or minimise? (From within Excel/VBA)
+AD4-
+AD4- I can do it with the VB Editor, and using an If routine with GetObject can
+AD4- do it with Word, but the same code won't work with Powerpoint.
+AD4-
+AD4- I just want a clear desktop so that the user can see and work on the form.
+AD4-
+AD4- Any help much appreciated
+AD4-
+AD4- Joe
+AD4-