Navigating

G

Gibbie

How do you set up a shortcut key in a worksheet so that you can specify
different cells to go to???
 
G

Gibbie

F5 does not work??? Can I set up a macros to move from cell to cell as data
is entered??
 
K

Ken Wright

In what way does it not work - What happens or works differently to what you
expected. You can also type a cell reference straight into the box above
column A and hit the Enter key.
 
N

Nick Hodge

Gibbie

We appear to be getting clues to your requirement ;-)

F5 will give you the 'go to' dialog to move to other cells, as in your
original request. So that should work.

If you want to move to specific cells, what are they as the macro code will
need to know that?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
G

Gibbie

Yes F5 works, but I want to navigate automatically to another cell in the
spreadsheet when I hit the tab key or a specified shortcut key. Will that
work??

Thanks very much
 
G

Gibbie

Well you can tell I'm not a programmer.......:)

The cells are as follows:
E7, S7,
E9, U9
B14, D14, H14, L14, O14
B16, D16, H16, L16, O16
B18, D18, H18, L18, O18
E21
E23
T23, T24, T25, T26


Many thanks
 
N

Nick Hodge

Gibbie

If you unlock the cells you want to navigate to,
(Format>Cells...>Protection) and then protect the worksheet.
(Tools>Protection>Protect sheet), you can press tab to cycle through the
cells unlocked

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
G

Gibbie

Ken,

I think my keys were locked as the F5 function was not working.....got it
now!!
 
G

Gibbie

Thank you Nick!! Have a good evening!!!

Julie

Nick Hodge said:
Gibbie

If you unlock the cells you want to navigate to,
(Format>Cells...>Protection) and then protect the worksheet.
(Tools>Protection>Protect sheet), you can press tab to cycle through the
cells unlocked

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
Click to expand...
 
Top