I have protected one of the worksheets in my workbook, so that it's only possible to select unlocked cells.
If I start on an unprotected sheet, then I can use Ctrl + Page Up / Down to navigate to the protected sheet as usual.
However, once I'm in the protected sheet, I get stuck there and the shortcut stops working. Instead of navigating to the next sheet, the shortcut moves me over to column AF in the same sheet!
What's happening!?!
Thanks, Helen
PS I haven't had any suggestions yet. So I've attached an example workbook. If you open it up and try navigating through the sheets with Ctrl + Page Down, you'll see it doesn't work. I would really appreciate an explanation for why the shortcut doesn't work anymore. Anyone any ideas?? Is there any way I can work round it to make the shortcut key work again?
Thanks again, Helen
Hello again . . .
It seems the shortcut for navigating between sheets will work if I allow the user to "select unlocked cells" and "select locked cells" when I protect the sheet. That way the user needs to tab between the unlocked cells instead of using the arrow keys. But at least the navigation shortcut between sheets doesn't stop working!
I would still be interested to hear from anyone who has any ideas about why the shortcut stops working if I don't allow the user to "select locked cells". Is it just one of the those funny Excel inconsistencies???
Thanks for those of you who pondered over this query. /Helen
Bookmarks