I have created an excel file with a useform. The file is
stored on a network.

How do i tell the userform to open automatically and fit
the screen full size. Other network users who use this
file have different screen settings which makes the form
too big or too small to view.

I would like the form to automatically adjust when opening.

Hi Gary:

In the UserForm module:

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

Note that this will make the UserForm fill the entire Application window. If
the latter is maximized, the UserForm will fill the full screen.

If this does not meet your needs, post back. To make the UserForm fill the
full screen regardless of the size of the Application window is a bit more
complicated.

Regards,

Vasant.
"Gary" wrote in message
...
I have created an excel file with a useform. The file is
stored on a network.

How do i tell the userform to open automatically and fit
the screen full size. Other network users who use this
file have different screen settings which makes the form
too big or too small to view.

I would like the form to automatically adjust when opening.