Keyboard Shortcut for Zooming

K

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?
 
R

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?
 
G

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
 
B

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
 
B

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
 
K

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


---


.
Fantastic!!!
Click to expand...

Thanks for your help!!!!
 
K

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


---


.
Good point Bob - I'll add it in. Makes things so much
Click to expand...
easier!!!

Thanks for your help..

Kristin
 
A

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
 
R

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
 
R

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
 
P

Peo Sjoblom

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

--

Regards,

Peo Sjoblom


RagDyer said:
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
Click to expand...
 
R

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


RagDyer said:
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
Click to expand...
 
Top