I have a spreadsheet in excel that when opened, it comes up with a user form. Well, this form is going to be used by about 7,000 users with about 7,000 computers. Well, I think all of you well know that everyones screen resolution is going to be different. Is there a way that when the user opens the form that it will automatically fit the form to their screen, so that nothing is hidden because their screen is too small??? I could really use this help.