Navigate in a big worksheet

[Rockbear]

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

 

[Earl Kiosterud]

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).

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Earl Kiosterud]

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

 

[Rick Rothstein \(MVP - VB\)]

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