Navigate in a big worksheet
 

Is it possible to make navigation buttons in a worksheet, or at the tool menu
for navigating in a sheet

Would be good to push a button and go from the active cell D2 to cell F128,
snd when I have done the input in F128, there is a button there to go
back...save me a lot of time...

and can one use the button to go to another sheet?

Its no problem if I need to put the button in the worksheet
--
Just a regular user

Navigate in a big worksheet
 

Rockbear,

Record macros to do these things (Tools, Macro, Record new macro). Then create the buttons
(Autoshapes on drawing toolbar). Then right-click each autoshape and assign to the
appropriate macro.

Sometimes Excel likes to move your graphics around. If that happens, select them all, then
group them (right click menu).
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Rockbear" wrote in message
...
Is it possible to make navigation buttons in a worksheet, or at the tool menu
for navigating in a sheet

Would be good to push a button and go from the active cell D2 to cell F128,
snd when I have done the input in F128, there is a button there to go
back...save me a lot of time...

and can one use the button to go to another sheet?

Its no problem if I need to put the button in the worksheet
--
Just a regular user

Navigate in a big worksheet
 

You said "active cell D2"... are we always talking about D2 or are we always
talking about the active cell even if that is different from D2?

Rick


"Rockbear" wrote in message
...
Is it possible to make navigation buttons in a worksheet, or at the tool
menu
for navigating in a sheet

Would be good to push a button and go from the active cell D2 to cell
F128,
snd when I have done the input in F128, there is a button there to go
back...save me a lot of time...

and can one use the button to go to another sheet?

Its no problem if I need to put the button in the worksheet
--
Just a regular user

Navigate in a big worksheet
 

If the buttons you requested need to remember from where they came when you want to return
from F128, then it will take more than a recorded macro -- it will require writing come
macro code. I think Rick was getting at this in his post.

Also consider Windows - Split to keep F128 visible at all times. Then you don't need
buttons to move about.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Earl Kiosterud" wrote in message
...
Rockbear,

Record macros to do these things (Tools, Macro, Record new macro). Then create the
buttons (Autoshapes on drawing toolbar). Then right-click each autoshape and assign to
the appropriate macro.

Sometimes Excel likes to move your graphics around. If that happens, select them all,
then group them (right click menu).
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Rockbear" wrote in message
...
Is it possible to make navigation buttons in a worksheet, or at the tool menu
for navigating in a sheet

Would be good to push a button and go from the active cell D2 to cell F128,
snd when I have done the input in F128, there is a button there to go
back...save me a lot of time...

and can one use the button to go to another sheet?

Its no problem if I need to put the button in the worksheet
--
Just a regular user

Navigate in a big worksheet
 

Actually, IF the OP always wanted to return to D2, then I was going to
propose giving both D2 and F128 names and using the Name Box to move back
and forth between them. However, if the return was to the ActiveCell rather
than to D2, that wouldn't work and then a VBA/macro solution would be
necessary. Unfortunately, the OP's choice of words left me confused; and I
didn't want to confuse the OP with my Name Box solution if what he wanted
was the ActiveCell solution only.

Rick


"Earl Kiosterud" wrote in message
...
If the buttons you requested need to remember from where they came when
you want to return from F128, then it will take more than a recorded
macro -- it will require writing come macro code. I think Rick was
getting at this in his post.

Also consider Windows - Split to keep F128 visible at all times. Then you
don't need buttons to move about.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Earl Kiosterud" wrote in message
...
Rockbear,

Record macros to do these things (Tools, Macro, Record new macro). Then
create the buttons (Autoshapes on drawing toolbar). Then right-click
each autoshape and assign to the appropriate macro.

Sometimes Excel likes to move your graphics around. If that happens,
select them all, then group them (right click menu).
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Rockbear" wrote in message
...
Is it possible to make navigation buttons in a worksheet, or at the tool
menu
for navigating in a sheet

Would be good to push a button and go from the active cell D2 to cell
F128,
snd when I have done the input in F128, there is a button there to go
back...save me a lot of time...

and can one use the button to go to another sheet?

Its no problem if I need to put the button in the worksheet
--
Just a regular user