View zoom changes on worksheets not being compared
Performs a cell-by-cell comparison of Excel Worksheets.
Brought to you by:
stevetowner
Menu
▾
▴
#58 View zoom changes on worksheets not being compared
With the recent introduction of window tiling during the selection of the before & after files to compare if you have multiple other windows open to other files, the zoom of the other files can change during the selection process.
I typically keep my master worksheet in 80%, but receive a couple of other files to compare that are at 100% zoom. During the selection of before and after somehow my master worksheet that I am not going to touch has its' zoom changed to 100%.
Okay, I have changed the code so that on the first page, the windows are tiles, but not zoomed or synched side by side. This allows the selection of the desired workbook without changing their properties. Clicking next then applies tiling again, but with synched zoom and scrolling.
Steve