grd
Board Regular
- Joined
- Oct 19, 2005
- Messages
- 210
Hi
I have a spreadsheet (2003) which has a worksheet which I have protected with only the "select unlocked cells" option ticked.
Now, when entering data the selection moves after enter despite the option being deselected in Tools>Options>Edit.
The selection does not move when the option to "select locked cells" is ticked as well when protecting the worksheet.
Can anyone suggest why this should be and how to prevent the selection from moving as it is a "feature" which I find particularly annoying.
Thanks
Graham
I have a spreadsheet (2003) which has a worksheet which I have protected with only the "select unlocked cells" option ticked.
Now, when entering data the selection moves after enter despite the option being deselected in Tools>Options>Edit.
The selection does not move when the option to "select locked cells" is ticked as well when protecting the worksheet.
Can anyone suggest why this should be and how to prevent the selection from moving as it is a "feature" which I find particularly annoying.
Thanks
Graham