MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Change function of key


Posted by jssp on June 26, 2001 3:29 PM


Is it possible to change the keyboard so that when you
press ENTER, or "arrow", you move to the next Sheet?

Perhaps some Macro?

Thanks!


Posted by Kevin James on June 26, 2001 3:47 PM

very dangerous request

How are you going to tell the application when all you really want is to press Enter?

Logistics and Logic, my friend. Yes a macro can be assigned to a key sequence, but you don't want it to go to the Enter key.

Posted by jssp on June 27, 2001 7:14 AM

Re: very dangerous request


I see what you mean...

The reason I was looking into this, is because
I'm preparing an Excel file, and I wanted it to
look like a PowerPoint presentation. So when
the user opens the file, pressing <Enter> will
move you to the next Sheet, which will have the
next "slide". The user will not have to insert
numbers...

The user can change settings for graphs but it's
only by using buttons. And to make it easy, when
you press "Enter" (or "PgDown") you'll move to the
next Sheet... Anyways, for anybody who's interested
I found the answer:

Code:

Sub ChangeKey
Application.onkey "~", "NameOfProcedureToRun"
End sub


Sub NameOfProcedureToRun
Activesheet.next.activate
End sub

To return everything to normal:

Sub CancelChangeKey
Application.onkey "~"
End sub

Posted by Kristen on July 01, 2001 9:57 PM

Wouldn't it be much less drastic to put a button on each page which calls a macro which selects the next worksheet?