![]() The macro can run every time the workbook is opened, and thereby set the zoom factor. The second workaround is to create a macro that gets saved with the workbook. ![]() (On some systems you may need to hold down the Ctrl key in order for the scroll wheel to adjust the zoom factor.) There are a multitude of ways to do this, but the easiest involve the Zoom setting on the Formatting toolbar, or using the scroll wheel on your mouse. First, you can simply adjust the zoom factor once you open the workbook. There are only two possible solutions to this problem. If you don't have the same size monitor as Wanda, then the workbook may be almost illegible on your system. Thus, when Wanda saves the workbook and hands it off to you, when you open it, the workbook is still displayed at whatever zoom factor Wanda last used. The problem is that the zoom factor is saved with the workbook. ![]() The purpose, of course, is so she isn't overpowered by things that look very large at the full zoom factor. For instance, if your colleague (Wanda) has a huge monitor, it wouldn't be uncommon for her to reduce the zoom factor on Excel to 75% or even 60%. If you work with workbooks first worked on by your colleagues, you may be frustrated by the zoom factor applied to those workbooks by those others.
0 Comments
Leave a Reply. |