HOW TO MOVE CURSOR

[Fernando Duran]

HI, I was wondering how to move the cursor to cells where information
needs to be input... with xp is easu to do it, but I didn't find the
same in Excel 97.
How you can do it in Excel 97?

Fernando

 

[Ron de Bruin]

Hi Fernando

You don't give a lot of information but this get you started

If you have protect your sheet you can use the Tab key to jump to the next unprotected cell.


With code in the Thisworkbook module you can use this :
Try it on a test workbook

You can only select unprotected cells this way in each sheet.
If you press Enter you go to the next unprotected cell.

Right click on the Excel icon next to File in the menubar
choose view code
paste it in there
Alt-Q to go back to Excel

Private Sub Workbook_Open()
Dim Sh As Worksheet
Application.ScreenUpdating = False
For Each Sh In ThisWorkbook.Worksheets
Sh.Select
Sh.Protect userinterfaceonly:=True
Sh.EnableSelection = xlUnlockedCells
Next
Sheets(1).Select
Application.ScreenUpdating = True
End Sub

Save and close the file
When you open it again it will work like I said

 

[Rafael Ortiz]

Are you talking about just navigating to "user input" cells? This could be
done by formatting the user input cells as unlocked (Format, Cells,
Protection, de-select Locked), then protect the sheet (the rest of the cells
should have the default format protection of "Locked")- then the user can
just use the Tab key to quickly navigate to the input cells...

MRO