PDA

View Full Version : [SOLVED] Enable CTRL+HOME, CTRL+END



pegbol
06-20-2005, 06:36 AM
.
.

Hello Masters,


I have a problem. It is the next:


Let's say:
I have locked all the cells of my Sheet except a range from B5:F10

Then, I protect the Sheet with only the option:
Select unlocked cells


Now, I try to use:
CTRL+HOME
CTRL+END
CTRL+PAGE UP
CTRL+PAGE DOWN


But, surprise.
Just these keys doesn't work.

Why does that happen ?.
How can that be solved via VBA code?.


regards,
Pedro
.
.

Zack Barresse
06-20-2005, 02:28 PM
Hi Pedro,

It's doing exactly what you are telling it to do. It's not letting you select locked cells (if all of them are locked). You should not be able to select them with your mouse or move to them with your arrow keys either.

Unless I missed something. :dunno

pegbol
06-20-2005, 02:53 PM
.
.

Hi Zack,

Thank you for your reply.

The range B5:F10 is not locked.
Now, my question is: (protected Sheet with only Select unlocked cells option)
With the cursor in D7. Why if I use CTRL+HOME, the cursor doesn't go to B5 ?.
Other problem:
If I want to use CTRL+PAGE DOWN to go to the next Sheet, just doesn't go. Why happen that ?.

Appreciate your kind assistance.

regards,
Pedro
.
.

pegbol
06-20-2005, 04:07 PM
.
.

Please Masters, Help.
.
.

Zack Barresse
06-20-2005, 04:19 PM
I believe it's just the functional by-product of sheet protection. While the sheet is protection, just the HOME key will (should) function like the CTRL + HOME key while unprotected.

pegbol
06-20-2005, 04:51 PM
.
.

Yes!!!!!. Thank you.
The problem with CTRL+HOME and CTRL+END is solved.

Only, one last request:
What combination of keys should I need to go to next Sheet ? :bow:

best regards,
Pedro
.
.

Zack Barresse
06-20-2005, 05:04 PM
Sorry, the only way I know how to do that with a locked sheet is to use CTRL + SHIFT + PAGE UP/DOWN, but that will select multiple sheets and you'd still need to use your mouse to right click a sheet and select Ungroup Sheets..

pegbol
06-20-2005, 05:14 PM
.
.

Zack,

Thank you for your kind and valuable assistance.

I try to deal with CTRL+SHIFT+PAGE UP/DOWN.


best regards,
Pedro
:beerchug:
.
.