Keyboard Shortcut for Zooming

[Kristin]

Hi all,

I am a keyboard shorcut freak and would love to know if
there is a shortcut key to zoom a sheet in and out. If
not, should I record a macro to do this, I can do basic
record functions but am unsure as to how I can record
zooming in and out. Can anyone help?

 

[RagDyer]

Not exactly a keyboard shortcut, but have you tried:

<Tools> <Options> <General> tab,
And click on "Zoom On Roll With Intellimouse" ?
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi all,

I am a keyboard shorcut freak and would love to know if
there is a shortcut key to zoom a sheet in and out. If
not, should I record a macro to do this, I can do basic
record functions but am unsure as to how I can record
zooming in and out. Can anyone help?

 

[Guest]

yeah, not a bad option, but I am trying to get something
for the keyboard alone, I actually find the mouse slows me
down...

Kristin

 

[beeawwb]

These macros can be put in a module and activated by a keyboar
shortcut.

Sub Superzoomin()
Windows(1).Zoom = (Windows(1).Zoom + 1)
End Sub

Sub Superzoomout()
Windows(1).Zoom = (Windows(1).Zoom - 1)
End Sub

I just looked in the VBA help files to do it, might not be what yo
want. Obviously, the value can be changed to however much a zoom yo
want.

I had tested it with a button, but I just tested it with Ctrl+q an
Ctrl+w, and it's fun! Zoom in, zoom out. Zoom in....zoom out. Clou
goes up, cloud goes down. Cloud goes up, cloud goes down.

-Bo

 

[beeawwb]

One final bit of code.

Sub Resetzoom()
Windows(1).Zoom = 100
End Sub

That'll get you back to normal zoom. After playing around going to 10
and 400% zoom over and over again, I found it hard to zoom back to 100
accurately. Of course, you can also make many more Sub's that take yo
to your favorite preset zoom levels. Many possibilities.

Anyway, back to work.

-Bo

 

[Kristin]

-----Original Message-----
These macros can be put in a module and activated by a keyboard
shortcut.

Sub Superzoomin()
Windows(1).Zoom = (Windows(1).Zoom + 1)
End Sub

Sub Superzoomout()
Windows(1).Zoom = (Windows(1).Zoom - 1)
End Sub

I just looked in the VBA help files to do it, might not be what you
want. Obviously, the value can be changed to however much a zoom you
want.

I had tested it with a button, but I just tested it with Ctrl+q and
Ctrl+w, and it's fun! Zoom in, zoom out. Zoom in....zoom out. Cloud
goes up, cloud goes down. Cloud goes up, cloud goes down.

-Bob


---
Message posted

.
Fantastic!!!

Thanks for your help!!!!

 

[kristin]

-----Original Message-----
One final bit of code.

Sub Resetzoom()
Windows(1).Zoom = 100
End Sub

That'll get you back to normal zoom. After playing around going to 10%
and 400% zoom over and over again, I found it hard to zoom back to 100%
accurately. Of course, you can also make many more Sub's that take you
to your favorite preset zoom levels. Many possibilities.

Anyway, back to work.

-Bob


---
Message posted

.
Good point Bob - I'll add it in. Makes things so much

easier!!!

Thanks for your help..

Kristin

 

[Amr Tabbarah]

Kristin,

As an alternative to the "permanenet feature" proposed by RagDyer, you
could use Ctrl + Roll with Intellimouse. In this way, you would be able
to keep the main "wheel" funtion of quick moving up or down and, with
the use of the Ctrl, obtain the zoom-in and zoom-out feature.

Amr

 

[Andy]

This file might be a help. It creates an add-in that gives you interactive
zoom capability. It's not the keyboard solution you want, but it might point
you in the rigth direction.

http://www.bygsoftware.com/examples/excel_addin.htm
The code is open and commented.

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

 

[RagDyer]

Learned something new today - Thanks
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

message Kristin,

As an alternative to the "permanenet feature" proposed by RagDyer, you
could use Ctrl + Roll with Intellimouse. In this way, you would be able
to keep the main "wheel" funtion of quick moving up or down and, with
the use of the Ctrl, obtain the zoom-in and zoom-out feature.

Amr

 

[Peo Sjoblom]

If you use IE you can do the same with WebPages..

 

[RagDyer]

Yea Peo, that burns me up.

I use it all the time in IE, but didn't put the two together.

And that's even after I discovered that the old IE trick of "<Ctrl> W" - for
closing those sneaky web pages that disable the "Back" button, also works in
XL, just like <Ctrl> F4 !(easier one hand operation)

Sometimes my mind adds ... and sometimes it subtracts. <bg>
--

Regards,

RD

 

[Peo Sjoblom]

Hmm. I though those pages (back button disabled) only existed for "Naughty"
WebPages? <g>

--

Regards,

Peo Sjoblom

Yea Peo, that burns me up.

I use it all the time in IE, but didn't put the two together.

And that's even after I discovered that the old IE trick of "<Ctrl> W" - for
closing those sneaky web pages that disable the "Back" button, also works in
XL, just like <Ctrl> F4 !(easier one hand operation)

Sometimes my mind adds ... and sometimes it subtracts. <bg>
--

Regards,

RD

 

[RagDyer]

MY DEAR SIR,
I'll have you know that I never, ever ..........
<g>


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------



Hmm. I though those pages (back button disabled) only existed for "Naughty"
WebPages? <g>

--

Regards,

Peo Sjoblom

Yea Peo, that burns me up.

I use it all the time in IE, but didn't put the two together.

And that's even after I discovered that the old IE trick of "<Ctrl> W" - for
closing those sneaky web pages that disable the "Back" button, also works in
XL, just like <Ctrl> F4 !(easier one hand operation)

Sometimes my mind adds ... and sometimes it subtracts. <bg>
--

Regards,

RD