User Forms - Max Me
 

You could hide the application (and remember to reshow it when your userform is
dismissed).

application.visible = false
userform1.show
....
application.visible = true
.....

But then other stuff will be visible instead of excel.

Or you could just fill all of excel's window:

Private Sub UserForm_Initialize()
With Me
.Top = Application.Top
.Left = Application.Left
.Height = Application.Height
.Width = Application.Width
End With
End Sub

Sgwapt wrote:

Is there a way to manipulate user form to maximize when initialized?
I am currently using a default size for all my forms using zoom integer but with different station settings on network environment I noticed they can still see the background. I would like to prevent that ability.
Thanks for your help
--
George G
Quality Director
Fox Lake IL USA

--

Dave Peterson