Something distorted my Workbook and everything within

%3CLINGO-SUB%20id%3D%22lingo-sub-1075430%22%20slang%3D%22en-US%22%3ESomething%20distorted%20my%20Workbook%20and%20everything%20within%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1075430%22%20slang%3D%22en-US%22%3EI'm%20working%20on%20a%20Workbook%20in%20XLSM%20format%20and%20editing%20some%20userform.%20At%20that%20time%2C%20I%20was%20using%20a%204k%20display%20with%20the%20Scaling%20options%20under%20Windows'%20Display%20Settings%20set%20to%20225%25.%20Suddenly%2C%20my%20laptop%20went%20into%20BSOD.%20I%20figured%20WTH%20and%20went%20with%20restarting%20it%20and%20continued%20with%20my%20work.%3CBR%20%2F%3E%26amp%3Bnbsp%3B%3CBR%20%2F%3EThat's%20before%20the%20incident.%20Then%20the%20horrible%20non-stop%20problem%20occurred.%3CBR%20%2F%3E%26amp%3Bnbsp%3B%3CBR%20%2F%3EWhenever%20I%20open%20the%20workbook%2C%20my%20entire%20workbook%20-%20every%20column%2C%20every%20button%2C%20every%20image%2C%20is%20stretched%20-%20in%20a%20way%20that%20I%20believe%20is%20225%25%20of%20what%20I%20originally%20set%20them%20as.%20In%20that%20case%2C%20I%20cannot%20click%20any%20of%20the%20buttons%20(as%20they're%20in%20a%20weird%20state)%2C%20and%20even%20if%20I%20tried%20twice%20to%20manually%20correct%20everything%20based%20on%20a%201080p%2C%20100%25%20Scaled%20monitor%20(which%20my%20office%20desktop%20and%20other%20coworkers%20often%20used)%2C%20it%20would%20revert%20to%20this%20stretched%20and%20distorted%20state%20whenever%20I%20reopen%20the%20workbook.%3CBR%20%2F%3E%26amp%3Bnbsp%3B%3CBR%20%2F%3EI've%20tried%20the%20following%3A%3CBR%20%2F%3E1)%20Open%20the%20backed%20up%20versions%20(up%20to%206%20months%20old)%20and%20the%20distortion%20would%20still%20occur%3CBR%20%2F%3E2)%20Tried%20a%20new%20computer%20and%20the%20distortion%20remains%3CBR%20%2F%3E3)%20Tested%20the%20file%20on%20local%20drive%2C%20Google%20Drive%2C%20OneDrive%20and%20Dropbox%20and%20the%20problem%20would%20remain.%20It's%20not%20a%20software%20conversion%20issue%3CBR%20%2F%3E4)%20Tried%20a%20new%20workbook%20without%20VBA%2C%20and%20the%20problem%20is%20gone%2C%20but%3CBR%20%2F%3E5)%20Tried%20a%20few%20other%20workbooks%20with%20VBA%20and%20the%20problem%20is%20there%20for%20some%20but%20not%20for%20others%3CBR%20%2F%3E6)%20Opened%20the%20workbooks%20under%20safe%20mode%2C%20and%20the%20problem%20is%20gone%3CBR%20%2F%3E%26amp%3Bnbsp%3B%3CBR%20%2F%3EThis%20is%20the%20'Normal'%20looking%20sample%20worksheet.%20As%20you%20can%20see%2C%20everything%20is%20fine.%3CBR%20%2F%3E%3CBR%20%2F%3E%26amp%3Bnbsp%3B%3CBR%20%2F%3E%26amp%3Bnbsp%3B%3CBR%20%2F%3ENow%2C%20the%20same%20file%2C%20unedited%2C%20but%20opened%20under%20normal%20mode%3CBR%20%2F%3E%3CBR%20%2F%3E%26amp%3Bnbsp%3B%3CBR%20%2F%3E%26amp%3Bnbsp%3B%3CBR%20%2F%3EAs%20you%20can%20clearly%20see%2C%20the%20screen%20is%20stretched%20out%20based%20on%20where%20the%20end%20of%20the%20columns%20are.%20And%20as%20you%20can%20see%2C%20the%20buttons%20are%20deformed%2C%20and%20the%20logos%20and%20the%20picture%20in%20the%20middle%20are%20stretched%20out%20of%20proportion.%3CBR%20%2F%3E%26amp%3Bnbsp%3B%3CBR%20%2F%3EI%20will%20attach%20the%20file%20for%20anyone%20interested%20in%20giving%20it%20a%20go.%20Please%20help!%3CBR%20%2F%3E%26amp%3Bnbsp%3B%3CBR%20%2F%3E%26amp%3Bnbsp%3B%3CBR%20%2F%3EExcel%20Ver%3A%2016.0.12410.20000%20x64%20MSO%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1075430%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor
I'm working on a Workbook in XLSM format and editing some userform. At that time, I was using a 4k display with the Scaling options under Windows' Display Settings set to 225%. Suddenly, my laptop went into BSOD. I figured WTH and went with restarting it and continued with my work.
 
That's before the incident. Then the horrible non-stop problem occurred.
 
Whenever I open the workbook, my entire workbook - every column, every button, every image, is stretched - in a way that I believe is 225% of what I originally set them as. In that case, I cannot click any of the buttons (as they're in a weird state), and even if I tried twice to manually correct everything based on a 1080p, 100% Scaled monitor (which my office desktop and other coworkers often used), it would revert to this stretched and distorted state whenever I reopen the workbook.
 
I've tried the following:
1) Open the backed up versions (up to 6 months old) and the distortion would still occur
2) Tried a new computer and the distortion remains
3) Tested the file on local drive, Google Drive, OneDrive and Dropbox and the problem would remain. It's not a software conversion issue
4) Tried a new workbook without VBA, and the problem is gone, but
5) Tried a few other workbooks with VBA and the problem is there for some but not for others
6) Opened the workbooks under safe mode, and the problem is gone
 
This is the 'Normal' looking sample worksheet. As you can see, everything is fine.

 
 
Now, the same file, unedited, but opened under normal mode

 
 
As you can clearly see, the screen is stretched out based on where the end of the columns are. And as you can see, the buttons are deformed, and the logos and the picture in the middle are stretched out of proportion.
 
I will attach the file for anyone interested in giving it a go. Please help!
 
 
Excel Ver: 16.0.12410.20000 x64 MSO
0 Replies