Can Ctrl+Page Up &Ctrl+Page Down be blocked in my Excel App. 3

[Acquaman]

Hello!
Thanks for your response, if possible.
I really need to prevent users of my Excel Application from switching between Sheets using Ctrl+Page Up & Ctrl+Page Down. I really prey someone can help! Thanks.
Sincerely,
Acquaman

 

[PHV]

Take a look at the Key_Up,Key_Down, ... events

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[TonyJollans]

Hi Acquaman,

You can make a key combination have no effect by using OnKey ..

[blue]Application.Onkey "^{PGUP}", ""
Application.Onkey "^{PGDN}", ""[/blue]

To reset them back to their default behaviour, use ..

[blue]Application.Onkey "^{PGUP}"
Application.Onkey "^{PGDN}"[/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

 

[Acquaman]

YES!!!
Thank you very much for your responses - and so FAST!
Greatfully,
Acquaman