Strange keyboard-shortcut behavior in protected sheet

garyfritz

New Member
Joined
Apr 30, 2011
Messages
20
I've protected the first 12 rows of a sheet, and I have tables & calculations below that. In this protected sheet, a few keys act strangely.
* HOME doesn't move horizontally to column A of the current row; it moves to A13, the top-left unprotected cell.
* CTRL-Next and CTRL-Prev don't move between sheets in the file; they scroll the sheet right/left.

In other (empty) sheets of the same file, HOME/etc work the way I expect.

???
 
Last edited:

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
When you protected this sheet, a dialog should have popped up asking whether you wanted users of the worksheet to be able to select locked cells. I think you might have left this unchecked. To fix this, unprotect this worksheet and then protect it again - the dialog will reappear and the first option will say 'Select Locked Cells'. Make sure this is checked.

I'm not sure about the scrolling issue. Is Scroll Lock on?
 
Upvote 0
No, I specified that users cannot select locked cells. That works properly -- you can't move the cursor above row 13.

No, Scroll Lock is not on. This only happens in this locked sheet. Other sheets in the SAME FILE don't do this.
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,327
Members
452,635
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top