max76
08-25-2017, 10:07 AM
Hi everybody,
I've a userform on Word with several buttons (activeX) on it that are perfectly aligned on my PC screen at home (widescreen) with a high resolution.
The problem arises when I open the file with the userform at work where the screen has a smaller resolution. The result is that the same buttons are much bigger on this screen but unfortunately the distances among them aren't increased accordingly, therefore all the buttons overlap making the userform a mess.
I'm wondering if there's a way to use a sort of conditional macro that can avoid this mess and adjust all the elements on the userform (including distances among objects) based on the different resolution ratio?
Thank you in advance for your support.
Regards
Massimo
I've a userform on Word with several buttons (activeX) on it that are perfectly aligned on my PC screen at home (widescreen) with a high resolution.
The problem arises when I open the file with the userform at work where the screen has a smaller resolution. The result is that the same buttons are much bigger on this screen but unfortunately the distances among them aren't increased accordingly, therefore all the buttons overlap making the userform a mess.
I'm wondering if there's a way to use a sort of conditional macro that can avoid this mess and adjust all the elements on the userform (including distances among objects) based on the different resolution ratio?
Thank you in advance for your support.
Regards
Massimo