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

On reflection, KeepItCool did give me most of the answer I needed with
Application.Visible (instead of +ACI-windowstate.xlminimized+ACI-), which at least
keeps the form +ACI-on top+ACI- of any other open application windows, if I use
steve's effort as well, I can acheive what I want, but for projects which
might only have two textboxes and one button they will be a bit lost+ACE- I
suppose I could fill the rest of the space with a pretty picture :)

thanks to all for help

The learning curve is still a vertical climb+ACE-

Joe

+ACI-Ron de Bruin+ACI- +ADw-rondebruin+AEA-kabelfoon.nl+AD4- wrote in message
news:ubIdzUWmDHA.3612+AEA-TK2MSFTNGP11.phx.gbl...
Ahh you mean a Userform

--
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:3f96ff2c+ACQ-1+AF8-1+AEA-mk-nntp-2.news.uk.tiscali.com...
+AD4- Ron
+AD4-
+AD4- There is that way, but I want users to concentrate on data entry on a
form,
+AD4- and not be too distracted by other activity on screen. The aim is to
create
+AD4- what +ACI-looks like+ACI- a standalone app, even though it is really Excel?
+AD4-
+AD4- Joe
+AD4-
+AD4- +ACI-Ron de Bruin+ACI- +ADw-rondebruin+AEA-kabelfoon.nl+AD4- wrote in message
+AD4- news:uvqHFkNmDHA.744+AEA-tk2msftngp13.phx.gbl...
+AD4- Why don't you maximize Excel and the Workbook
+AD4-
+AD4- Application.WindowState +AD0- xlMaximized
+AD4- ActiveWindow.WindowState +AD0- xlMaximized
+AD4-
+AD4-
+AD4- --
+AD4- Regards Ron de Bruin
+AD4- (Win XP Pro SP-1 XL2002 SP-2)
+AD4- www.rondebruin.nl
+AD4-
+AD4-
+AD4-
+AD4- +ACI-Joe 90+ACI- +ADw-joe+AEA-sillyspambimma.me.uk(remove silly spam)+AD4- wrote in message
+AD4- news:3f96e2a4+ACQ-1+AF8-1+AEA-mk-nntp-2.news.uk.tiscali.com...
+AD4- +AD4- Is there a way with code to make all open applications on the desktop
+AD4- either
+AD4- +AD4- hide or minimise? (From within Excel/VBA)
+AD4- +AD4-
+AD4- +AD4- I can do it with the VB Editor, and using an If routine with GetObject
can
+AD4- +AD4- do it with Word, but the same code won't work with Powerpoint.
+AD4- +AD4-
+AD4- +AD4- I just want a clear desktop so that the user can see and work on the
form.
+AD4- +AD4-
+AD4- +AD4- Any help much appreciated
+AD4- +AD4-
+AD4- +AD4- Joe
+AD4- +AD4-
+AD4-
+AD4-