Does anyone know if I can load a user form, and either ;
1) code it to be fullscreen or maximized
2) or, make the Excel window where it is NOT visible behind the userform?

D.S.

DS,

Try something like the following to resize the form to fill the entire Excel
window.

With Application
UserForm1.Move .Left, .Top, .Width, .Height
End With
UserForm1.Show

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"D.S." wrote in message
...
Does anyone know if I can load a user form, and either ;
1) code it to be fullscreen or maximized
2) or, make the Excel window where it is NOT visible behind the userform?

D.S.

You can also try something like:

application.Visible = False
Userform1.show
Application.visible = True

--
Regards,
Tom Ogilvy

"D.S." wrote in message
...
Does anyone know if I can load a user form, and either ;
1) code it to be fullscreen or maximized
2) or, make the Excel window where it is NOT visible behind the userform?

D.S.

Thanks Chip & Tom. That will work nicely.

D.S.
"Tom Ogilvy" wrote in message ...
You can also try something like:

application.Visible = False
Userform1.show
Application.visible = True

--
Regards,
Tom Ogilvy

"D.S." wrote in message
...
Does anyone know if I can load a user form, and either ;
1) code it to be fullscreen or maximized
2) or, make the Excel window where it is NOT visible behind the userform?

D.S.