Change function of key

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.

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

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