Jeff,
You can use the ActiveWindow.Zoom = [value] property to set the Zoom rate.
The challenging aspect is where to put the spinner/scroll bar. Since you
don't want it on a particular sheet, one idea is to create a custom control
and add it to a current command bar (or create a new one), then have that
control kick off a userform with that contains the spinner/scroll bar.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758
"JEFF" wrote:
Hi All,
I would like to change my active sheet's zoom size using a Scroll or
Spinner... Not sure where to start -- any ideas?
TIA!