Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO MOVE CURSOR
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO MOVE CURSOR
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 "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA command to move cursor | Excel Discussion (Misc queries) | |||
move cursor on one sheet moves cursor on all sheets | Excel Discussion (Misc queries) | |||
How do I get tab to move the cursor one cell over rather than 8? | Excel Worksheet Functions | |||
Move cursor to next row | Excel Discussion (Misc queries) | |||
Move Cursor to A1 | Excel Discussion (Misc queries) |