How to save a workbook in a universal screen resolution format

[johnw993]

How do I save (or format) my workbook so that it will look exactly the same on any other computer, regardless of that computer's screen resolution?
My model looks great while I'm working in 1920 x 1200 resolution mode, but is practically unusable when I send it to anyone working on a system set to for instance 1280 x 800.
The workbook/model I am sending to other people contains VBA code, and a number of menus and data entry screens (UserForms). Its primarily the UserForms that appear completely out of whack when opened on other systems.

I suspect there must be a way to have Excel automatically adapt and look identical (as it does on my system) on any other computer, regardless off its screen resolution?

Question from a beginner. Any help is greatly appreciated.

[shg]

The recommendation from Stephen Bullen and others is that you create forms in two or more sizes, use Windows API to query the monitor resolution, and the use the appropriate-sized forms.

[johnw993]

Thank you shg for your quick reply. But I like to believe there must be a more efficient way of accomplishing this? Is there a means of using VBA code that will query the monitor resolution and adjusts the entire workbook? Btw: I'm not familiar with Windows API. I'm developing this model both in MAC OS and Windows simultaneously (VBA does not perform the same on both platforms and needs tweaking), and have 2 identical models available, depending on the platform of the user. I have not run into any issues with the MAC users, but Window users pose a problem.

[shg]

... and adjusts the entire workbook?

I don't know what that means.

[johnw993]

Sorry. I meant adjust the workbook to the screen resolution of the user, so the workbook, not just the Userforms, appear in the same format, size, look and feel as it was developed on my system.