Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merged cells withing Protected Sheets
I have a range of cells that we merged and then unlocked. When we protect
the sheet and say the user can only go to the unloced cells. We can tab thru until we get to the cell that created from a group of cells merged. it will then tab to the next cell and just keep going back and forth between those two forever. Any suggestions? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merged cells withing Protected Sheets
You must have merged rows and have other unlocked cells on the same row...
It confuses tab because the merged range is not just the upper left cell, but ALL of the cells in one. You can use a merged range if there are no other unlocked cells on the same row as one of the rows that have been merged. "Ann" wrote: I have a range of cells that we merged and then unlocked. When we protect the sheet and say the user can only go to the unloced cells. We can tab thru until we get to the cell that created from a group of cells merged. it will then tab to the next cell and just keep going back and forth between those two forever. Any suggestions? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merged cells withing Protected Sheets
Received email request for further explanation (from lurker) sharing here as
well: Say cells A1 and B3 are unlocked and the range D2:D4 has been merged and also has the locked property turned off. Protecting the sheet and unchecking select locked cells, allows the user to only select unlocked cells€¦ which means tab will move them to the next unlocked cell on the current row or, if there are no more on this row, the first unlocked cell on the next row. With the cells listed above, a tab from A1 will move you to D2, a tab from D2 will move you to B3, and a tab from B3 will move you to D3€¦ part of the merged range €“ but still technically the next unlocked cell. Of course, once the selection gets there, its really back in cell D2 - because of the merge - and a tab from cell D2 will move the selection to B3 and then youre stuck in a loop and it never makes it back to A1. (Though arrow keys and the mouse will still get you out€¦) Just one more reason to avoid merging cells! "BoniM" wrote: You must have merged rows and have other unlocked cells on the same row... It confuses tab because the merged range is not just the upper left cell, but ALL of the cells in one. You can use a merged range if there are no other unlocked cells on the same row as one of the rows that have been merged. "Ann" wrote: I have a range of cells that we merged and then unlocked. When we protect the sheet and say the user can only go to the unloced cells. We can tab thru until we get to the cell that created from a group of cells merged. it will then tab to the next cell and just keep going back and forth between those two forever. Any suggestions? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merged cells withing Protected Sheets
Un-merge the cells.
You have run into just one of a great host of problems created by merged cells. Gord Dibben MS Excel MVP On Fri, 9 May 2008 10:38:17 -0700, Ann wrote: I have a range of cells that we merged and then unlocked. When we protect the sheet and say the user can only go to the unloced cells. We can tab thru until we get to the cell that created from a group of cells merged. it will then tab to the next cell and just keep going back and forth between those two forever. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
Protected sheets and cells | Excel Worksheet Functions | |||
Copy/Cut/Paste of Merged Cells in Shared Protected Workbooks | Excel Discussion (Misc queries) | |||
Can you allow cells to be merged under a protected worksheet? | Excel Discussion (Misc queries) | |||
grouping of cells in protected sheets | Excel Worksheet Functions |