Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tabbing Order of Unproteced Cells
We have a spreadsheet that has protected cells (locked cells) and unprotected
cells so that only the unprotected cells can have data entered into them. Does anyone know if it is possible to set the order you tab through the unprotected cells (and how to do this). Right now, it just goes through the cells from left to right and we want to change that. Thanks in advance, Wayne |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tabbing Order of Unproteced Cells
You can set the sheet such that the user can only select unprotected cells by
setting that option on the Protect Sheet dialog which appears when you protect a sheet. That will not change the tab order only which cells tab will take you to. The only way to change the order to something custom is to use VBA code and that can get a bit messy if the active cell needs to jump around a lot. -- HTH... Jim Thomlinson "Wayne" wrote: We have a spreadsheet that has protected cells (locked cells) and unprotected cells so that only the unprotected cells can have data entered into them. Does anyone know if it is possible to set the order you tab through the unprotected cells (and how to do this). Right now, it just goes through the cells from left to right and we want to change that. Thanks in advance, Wayne |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tabbing Order of Unproteced Cells
When you protect it you're presented with a dialog box in which you can
specify to select locked cells or not. If you deselect this option you'll get the behavior you're looking for. Bob Umlas Excel MVP Mark your calendars for a 2-day advanced Excel conference June 17-18 '09 in Atlantic City, New Jersey - 4 sessions of ~3 hours each led by Jon Peltier and yours truly. Check here for details -- http://peltiertech.com/Training/2009...00906ACNJ.html ----------- Free 1-hour Excel webinars on tips & tricks or What's new in Excel 2007: check out http://www.iil.com/webinars/ ----------- Check out my book, "This isn't Excel, it's Magic!" on tips & tricks in excel 2003 at: http://www.iil.com/iil/excelmagic or in excel 2007 at: http://www.iil.com/iil_shortdescr.asp?sku=PT258 "Wayne" wrote in message ... We have a spreadsheet that has protected cells (locked cells) and unprotected cells so that only the unprotected cells can have data entered into them. Does anyone know if it is possible to set the order you tab through the unprotected cells (and how to do this). Right now, it just goes through the cells from left to right and we want to change that. Thanks in advance, Wayne |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tabbing Order of Unproteced Cells
I may be wrong, but I think the OP wants to set the tab order of going
through the unprotected cells, i.e. maybe going top to bottom instead of left to right, etc. I don't think that's possible in Excel - it will always go in a certain order when tabbing through the cells. You can't set the tab order of cells like you can set the tab order of controls on a userform, for example. Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TABBING BETWEEN PARTICULAR CELLS | Excel Worksheet Functions | |||
How do i setup tabbing order of cells? | Excel Discussion (Misc queries) | |||
Locked cells tabbing? | Excel Discussion (Misc queries) | |||
Tabbing to cells | Excel Worksheet Functions | |||
How do I change the tabbing order in an excel form? | Excel Discussion (Misc queries) |