Hello all, if someone has ever come accross a problem like this, can they please help..
I have a worksheet with the majority of cells protected and only 'data entry' cells unprotected. The protection works fine for most of the sheet, but for some reason a block of cells halfway down the page does not let the user mouse click on them to enter data. Instead Excel shows the 'hand' mouse pointer and will not let the user select the cells at all. The strange thing is that if you scroll to the cells using the keyboard, they work fine and data can be entered. This problem only happens when using the mouse.
The sheet is protected/unlocked cells correctly and the problem only affects a block of about ten lines. The cells before/after work fine..
Please help, as this is starting to baffle me
Not sure if it makes a difference, but the sheet is unprotected/protected by a macro prior to use. But this is just the standard macro recorded by the recorder..
I have a worksheet with the majority of cells protected and only 'data entry' cells unprotected. The protection works fine for most of the sheet, but for some reason a block of cells halfway down the page does not let the user mouse click on them to enter data. Instead Excel shows the 'hand' mouse pointer and will not let the user select the cells at all. The strange thing is that if you scroll to the cells using the keyboard, they work fine and data can be entered. This problem only happens when using the mouse.
The sheet is protected/unlocked cells correctly and the problem only affects a block of about ten lines. The cells before/after work fine..
Please help, as this is starting to baffle me
Not sure if it makes a difference, but the sheet is unprotected/protected by a macro prior to use. But this is just the standard macro recorded by the recorder..