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!

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!

Thanks for the response.... Actually, it can be on one particular sheet.
I'm not going to pretend to be an expert so... how do I tie this to the form?

Thanks

"galimi" wrote:

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!