Userform & Excel window

[D.S.]

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.

 

[Chip Pearson]

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

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.

 

[Tom Ogilvy]

You can also try something like:

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

--
Regards,
Tom Ogilvy

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.

 

[D.S.]

Thanks Chip & Tom. That will work nicely.

D.S.
You can also try something like:

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

--
Regards,
Tom Ogilvy

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.