Is there a way to have vb code (in Excel) determine the screensize /
resolution of the
computer used to view it. I have a spreadsheet that has custom userforms
that I have lined up along the right side on my screen, but when it opens
on another persons computer (with a narrower screen) the forms are cut off.
Is there a way to determine what the size of the actual display area is
(both width and height) so that I can adjust the positioning of the
userforms that I use.


Always find excellent answers in this group, I appreciate the help.

Jim