#1
|
|||
|
|||
Option buttons are distorted on some PCs
Recently, a spreadsheet has started displaying distorted controls on some PCs.
See the attachment for a picture of what is happening. They look fine when I create them. Any ideas on how to solve this? Thanks. |
#2
|
||||
|
||||
That is most likely a display driver issue. Try downloading & installing the latest display drivers for the PCs concerned.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks for the response, macropod.
I've checked that the drivers are the latest and Windows is up to date. (unless there is something I don't understand about how to do this.) Now it is acting up on my machine. I'm working on a Windows 10 64-bit SurfacePro 7 with an LG 34" WQHD widescreen attached via HDMI cable. I created the workbook with the LG screen as the working screen and the SurfacePro screen off. If I used extended displays or turn off the LG and turn on the SurfacePro screen only, the same issue occurs. I've read online (vba - Excel: the Incredible Shrinking and Expanding Controls - Stack Overflow) where others have this issue and have solved it by setting the control height and width on worksheet activation using shp.height = shp.height and shp.width = shp.width, and it seems to "undistort" the option buttons, but for some reason, it also moves them to a different location. It completely resizes buttons and dropdowns as well as moves them. It also moves checkboxes. Does the additional info give you any other ideas? |
Tags |
distorted controls, form controls |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Option Buttons - linking and control | natelfo | Visio | 8 | 01-25-2024 02:01 AM |
Falling at the last hurdle with Checkboxes and Option buttons | kiwimtnbkr | Excel Programming | 14 | 06-11-2019 10:03 AM |
Option buttons for multiple choice questions | ScottishPolarBear | Word | 4 | 12-02-2014 02:23 PM |
Display cells dependent on option buttons | inq80 | Excel | 0 | 09-01-2014 03:40 PM |
Word 2007 Option buttons - transparency | JacobThomas | Word VBA | 1 | 11-02-2011 05:40 AM |