HELP: Setting CNTL-SHIFT-F to invoke Excel2007 macro

  • Thread starter Thread starter Jay Somerset
  • Start date Start date
J

Jay Somerset

For years I have used CNTL-SHIFT-F to invoke an Excel macro I created
and use frequently. Works fine in Excel2000. However, I have been
unable to assign this key combination in Excel2007. CNTL-SHIFT-F
always opens up the Font dialog box.

How can I override this so that I can assign CNTL-SHIFT-F to a macro
of my choice? Can someone please help me ut here?

Thanks,
 
Say in module1 we have:

Sub hello()
MsgBox ("HELLO")
End Sub

running this:

Sub setshort()
Application.OnKey "+^{F}", "module1.hello"
End Sub


will assign the shortcut CNTRL-SHIFT-F to it
 
Hi,

It still works like 2000, you don't need to do anything special.

Choose Developer, Macros (in the Code group), select your macro and click
Options button at the bottom right. Hold down the Shift key and type the
letter F. You're done.
 
Hi,

I should add that to display the Developer tab on the ribbon choose File
(Office button), Excel Options, Popular and check the 3rd option.
 
Hi,

It still works like 2000, you don't need to do anything special.

Choose Developer, Macros (in the Code group), select your macro and click
Options button at the bottom right. Hold down the Shift key and type the
letter F. You're done.
Click to expand...

Been there, done that. Unfortunately it doesn't work for CNTL-SHIFT-F,
at least not on my Vista system with the Trial version of 2007. At
least not for me.
 
Been there, done that. Unfortunately it doesn't work for CNTL-SHIFT-F,
at least not on my Vista system with the Trial version of 2007. At
least not for me.
Click to expand...

Or perhaps iIshould say that it doesn't work if I record a new macro
and save the PERSONAL.xl?? in the new 2007 format. A personal.xls
file from Excel2000 that already has that macro key definition retains
it, however.
BUT, and here is another problem, you can't just save an existing
personal.xls under the new .xlsb format -- if you try, you get a "file
type mismatch" error every time you try and run Excel in the future.
 
Hi Jay,

'----------------
BUT, and here is another problem, you can't just save an existing
personal.xls under the new .xlsb format -- if you try, you get a "file
type mismatch" error every time you try and run Excel in the future.
'----------------

Try using Personal.xlsx or Personal.xlsm
 
Hi Jay,

'----------------
BUT, and here is another problem, you can't just save an existing
personal.xls under the new .xlsb format -- if you try, you get a "file
type mismatch" error every time you try and run Excel in the future.
'----------------

Try using Personal.xlsx or Personal.xlsm
Click to expand...
Tried that -- same result.
Finally went back to the 2000 version of personal.xls in the startup
folder. Problem will not reoccur until i nees to crrsate a new macro.
 
Back
Top