Home » Forums » Open Source Learning Center » Question and Answer

Shortcut keys don't work

Submitted by laks on 20 May, 2009 - 12:32

Suddenly my office 2007 shortcut keys are not working, both in excel and access 2007. For example, F8 to step into does not do anything. Alt+F8 does not work either.

It looks like I did something to turn off keyboard shortcuts. What could that be?

 

Thanks,

Laks

‹ Help with Dates Urgent PLZ HELP QUIZ THIS SUNDAY 4TH JANUARY 2010!!!! ›
»
Nick's picture

F8 not working

Submitted by Nick on 20 May, 2009 - 13:03.

hi Laks... odd one..

2 things I can suggest:

1. Test the onkey method to guarantee that F8 is doing something.

run abc, then go back to Excel and press F8.. if ur F8 key is working, u will get a messagebox. 

Sub abc()
Application.OnKey "{F8}", "hi"
End Sub
 
Sub hi()
MsgBox "hi"
End Sub
 
 
 

2. Make sure no code is currently running by pressing the reset (stop) button in VBA editor

Nick

 

»

F8

Submitted by laks on 20 May, 2009 - 17:18.

Hey, thx. Did that code, ran it. Then, tried F8. Nothing happened.

 

Odd indeed. Is there anyway I could have turned application keys? I have my macros and opened some from this site. Was there any playing with onKeys here? I might have accidentally 'improved' one of yours :)

 

- Laks

»
Nick's picture

F8

Submitted by Nick on 20 May, 2009 - 18:08.

not done any tips on that yet, but have added it to my list of things to do..

 u sure ur F8 key works then ?

 

»

Ooops

Submitted by laks on 20 May, 2009 - 18:37.

Nick, sorry to have wasted your time on this. I got a new Microsoft keyboard, which had a fn lock, which disabled my f8 (and all other f) key. I unlocked that and it is ok now.

Anyhow, onKey - I see some interesting use for it. Thanks for that tip.

 

- Laks

»

Fn key kidnapping

Submitted by Anonymous on 8 January, 2010 - 11:33.

Note: some 3rd party apps are prone to hijacking function keys - eg WinCinema sitting in sys-tray can take over Alt F4! Met this scenario twice last year. Simon

»
Nick's picture

F8

Submitted by Nick on 20 May, 2009 - 21:40.

no worries... gave me an idea for a tip

; - >

»