ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hand Cursor / Disabled Mouse When Sheet is Protected (https://www.excelbanter.com/excel-programming/371213-hand-cursor-disabled-mouse-when-sheet-protected.html)

EanW

Hand Cursor / Disabled Mouse When Sheet is Protected
 
I have an issue when I protect one sheet of a multi-sheet spreadsheet. The
Select Unlocked Cells and Select Locked Cells are check when enabling
protection (just like on other sheets which are working properly). On this
"bad" sheet the cursor changes from the plus sign to a hand and you cannot
select any cells with the mouse. You can move the cursor around with the
arrow keys and enter data into unlocked cells. I have discovered that this
behavior only seems to happens when a couple of cells are within view -- B24
and/or B25. When they are out of view the cursor goes back to a plus sign
and you can use the mouse to select cells. There does not appear to be
anything weird with these particular cells or lines and I have tried deleting
the cells, copying over the cells, deleting the lines and deleting the
columns. None of these actions have solved the problem. Any ideas before I
recreate the sheet from scratch... Thanks.


All times are GMT +1. The time now is 10:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com