Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi John
Select A5 and E14. Go menu Format Cells, Protection and unselect Locked. Now go menu Tools Protection Protect worksheet. Once protected then tabbing moves between unlocked cells only, the others are write protected. For your possible followup; can you set the tab order like A5, E14, B6, G2, .... no, there is no easy or user friendly way to do that. Possible but very awkward. HTH. Best wishes Harald "John" skrev i melding ... I have a Worksheet where certain fields are filled out is it possible to automatically move to the next field I want to populate without having to physically click on the cell I want. Something like Tab? So for example if I enter a value in A5 and the next field I want filled out is E14 it jumps to it once a value is put in A5? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
fields names do not show in excel 2007 pivot table fields list | New Users to Excel | |||
Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
Catalogue of fields' connection whit external fields ( sheets) | Excel Programming | |||
Catalogue of fields' connection whit external fields ( sheets) | Excel Programming | |||
Catalogue of fields' connection whit external fields ( sheets) | Excel Programming |