T
Tammy
Using Excel 2003. We have a workbook with 3 worksheets
with similar (but not exactly the same)
information/layout. There are no links, groups, etc.
between the sheets.
On each sheet they have 1 column where they have used
Merge and Center to merge about 10 rows several different
times. They have then set the desired cells to
be 'locked' using the correct steps. The locked cells
INCLUDE the merged and centered cells. They then turned
Protection on (with only the defaults checked).
The first worksheet still allows them to edit the merged
cells, even though it's locked and protected. The 2nd and
3rd worksheet are working correctly and do NOT allow
editing in those similar merged cells. There does not
appear to be any formatting differences etc on the first
worksheet. We have tried copying and pasting the data to
a new worksheet but the same things happens. We have also
tried 'unmerging' the cells then turning the protection
back on but we are STILL able to edit the single cells
even though if you look at their formatting 'locked' is
checked.
Any help would be greatly appreciated. Thanks!
with similar (but not exactly the same)
information/layout. There are no links, groups, etc.
between the sheets.
On each sheet they have 1 column where they have used
Merge and Center to merge about 10 rows several different
times. They have then set the desired cells to
be 'locked' using the correct steps. The locked cells
INCLUDE the merged and centered cells. They then turned
Protection on (with only the defaults checked).
The first worksheet still allows them to edit the merged
cells, even though it's locked and protected. The 2nd and
3rd worksheet are working correctly and do NOT allow
editing in those similar merged cells. There does not
appear to be any formatting differences etc on the first
worksheet. We have tried copying and pasting the data to
a new worksheet but the same things happens. We have also
tried 'unmerging' the cells then turning the protection
back on but we are STILL able to edit the single cells
even though if you look at their formatting 'locked' is
checked.
Any help would be greatly appreciated. Thanks!