Mostly, when we instruct users to use the extend display setting and the result is two screens both using native resolutions, we don't see the problem. The Width & Height properties don't shrink when queried (either in code or using the properties sheet), but apparently they DO change. I can then run this sub from any point in the code where the controls grow or shrink. Command Button) ' Restore original button size to solve windows bug that changes the button size to ' adjust to screen resolution, when not in native resolution mode of screen = my Position cb.
A simple solution to this problem is to ask the user to reboot their machine without any peripheral connections (projector) and then open the excel application again. There are a number of fixes around, but they seem hit and miss. Never the less, these are steps I took: I listed all shapes in the problem sheet (ws Form) on a blank sheet (Sheet1): Sub List Shapes() Dim sp Shape As Shape Dim int Row As Integer Sheet1. I do this by adding a control outside the freeze panes area, add it into the group but also hide the control so you don't see it.We have found that these settings cause serious problems with Excel buttons, especially Active X controls. Command Button) ' Save original button size to solve windows bug that changes the button size to ' adjust to screen resolution, when not in native resolution mode of screen my Position = my Position = cb.Sometimes, on repeated clicks, they shrink to unreadability; other times they expand to cover the whole screen. Width = 12 ' just making sure Next my Ctrl What I started doing a while back was to have a single sub that sets the size of all my controls. Left my Button.height = cb.height my Button.width = cb.width End Sub Sub Set Button Size(cb As MSForms.Write a brief, upbeat profile Nothing too deep or too long.Imagine you're talking to someone you've just met in a bar: how would you describe yourself and your lifestyle?