View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default HOW TO MOVE CURSOR

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

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Fernando Duran" wrote in message ...
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