how to customize zoom box view % for all new workbooks

[William Poh Ben]

My EXCEL workbook has standard view % in the zoom box - 200%, 100%, 75%,
50%, 25% and selection.

Does anyone know how do I change them to 150%, 120%. 100%, 90% and 80%,
so that this will be the same zoom spec when I open a new work book or
any worksheet ?

Thank you so much in advance for the help.

 

[Andy Wiggins]

These values can't be changed.

But this file might be a help:
http://www.bygsoftware.com/examples/zipfiles/mzoomer.zip
It's in the "Worksheet with VBA" section on page:

http://www.bygsoftware.com/examples/examples.htm

Interactively see the effect of changes you make to Excel's zoom setting.
Including, fitting the width of the current selection to the screen.

The code is open and commented.


--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "The Excel Auditor" and "Byg Tools for VBA"