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.