View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Richardson[_2_] Tim Richardson[_2_] is offline
external usenet poster
 
Posts: 5
Default OnKey for Alt f not overriding standard use of Alt-F

I want to use Alt F for something (toggle 'freeze panes').
I have this code in my personal.xls 'thisWorkbook' object module:

Private Sub Workbook_Open()
Set X.XL = Application
Application.OnKey "^+5", "applyFormatPercent"
'the macro procedure must be in a normal module. I use AppEvents
Application.OnKey "%f", "toggleFreezePanes"
End Sub


The first remapping, "applyFormatPercent" works fine (this gives me %
with one decimal point).

The second is not working. Alt-f always gives me the file menu.

The macro toggleFreezePanes works fine.

I also tried
Application.OnKey "%+f", "toggleFreezePanes" but I have the same
result.


Any ideas?

regards,

Tim