Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moved automatically to the next specified cell
Hello, Is it possible, in Excel 2002, to enter data only into some cells, and then be moved automatically to the next specified cell? Also, I want that all the other cells of the sheet that are not used to be locked. Thanks for your help! Fred's |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moved automatically to the next specified cell
Unlock used cells (FormatsCellsProtection Tab)
Protect worksheet (ToolsProtectionSheet protection) Pressing Tab key moves cursor to the next unlocked cell on a protected sheet. Regards, Stefi €žFred's€ť ezt Ă*rta: Hello, Is it possible, in Excel 2002, to enter data only into some cells, and then be moved automatically to the next specified cell? Also, I want that all the other cells of the sheet that are not used to be locked. Thanks for your help! Fred's |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moved automatically to the next specified cell
On 12 mar, 10:56, Stefi wrote:
Unlock used cells (FormatsCellsProtection Tab) Protect worksheet (ToolsProtectionSheet protection) Pressing Tab key moves cursor to the next unlocked cell on a protected sheet. Regards, Stefi „Fred's” ezt írta: Hello, Is it possible, in Excel 2002, to enter data only into some cells, and then be moved automatically to the next specified cell? Also, I want that all the other cells of the sheet that are not used to be locked. Thanks for your help! Fred's- Masquer le texte des messages précédents - - Afficher le texte des messages précédents - - - - - - - - - Thank you for your help! Last question. Is it possible to choose the way the cells are moving?? Thank you. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moved automatically to the next specified cell
It requires VBA scripts (event macros).
Stefi €žStefi€ť ezt Ă*rta: Unlock used cells (FormatsCellsProtection Tab) Protect worksheet (ToolsProtectionSheet protection) Pressing Tab key moves cursor to the next unlocked cell on a protected sheet. Regards, Stefi €žFred's€ť ezt Ă*rta: Hello, Is it possible, in Excel 2002, to enter data only into some cells, and then be moved automatically to the next specified cell? Also, I want that all the other cells of the sheet that are not used to be locked. Thanks for your help! Fred's |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moved automatically to the next specified cell
You can choose the order of the unlocked cells to move to if you create a
named range. See Bob Phillips' site for more info on this mehtod. http://www.xldynamic.com/source/xld.xlFAQ0008.html Note: it says "without protection" but you can also use the method with protected sheet. Gord Dibben MS Excel MVP On Thu, 12 Mar 2009 08:07:58 -0700 (PDT), "Fred's" wrote: On 12 mar, 10:56, Stefi wrote: Unlock used cells (FormatsCellsProtection Tab) Protect worksheet (ToolsProtectionSheet protection) Pressing Tab key moves cursor to the next unlocked cell on a protected sheet. Regards, Stefi „Fred's” ezt írta: Hello, Is it possible, in Excel 2002, to enter data only into some cells, and then be moved automatically to the next specified cell? Also, I want that all the other cells of the sheet that are not used to be locked. Thanks for your help! Fred's- Masquer le texte des messages précédents - - Afficher le texte des messages précédents - - - - - - - - - Thank you for your help! Last question. Is it possible to choose the way the cells are moving?? Thank you. |
#6
|
|||
|
|||
1.Select the cells that you want to tab between
2.Right clickformat cellsprotection tabuncheck the locked uption 3.Select toolsprotectionprotect sheetgive passwordok Now you can use the tab key to move between selected cells Chris ------ Convert your Excel spreadsheet into an online calculator. http://www.spreadsheetconverter.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I keep a hyperlink valid if the link to cell is moved? | Excel Discussion (Misc queries) | |||
can the data be moved to another cell not using any macro? | Excel Worksheet Functions | |||
Lock cell reference in formula, even when moved with click & drag | Excel Worksheet Functions | |||
MSExcel--words in a cell separated by comma need to be moved into. | Excel Worksheet Functions | |||
How do I automatically update chart source data links for moved fi | Charts and Charting in Excel |