HOW TO MOVE CURSOR

  • Thread starter Thread starter Fernando Duran
  • Start date Start date
F

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