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,
---
Jay (remove dashes for legal email address)

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
--
Gary''s Student - gsnu200726

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.
--
Cheers,
Shane Devenshire


"Jay Somerset" wrote:

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,
---
Jay (remove dashes for legal email address)

On Sat, 2 Jun 2007 11:59:00 -0700, ShaneDevenshire
wrote:

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.

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.
---
Jay (remove dashes for legal email address)

On Sun, 03 Jun 2007 08:01:06 -0400, Jay Somerset
wrote:

On Sat, 2 Jun 2007 11:59:00 -0700, ShaneDevenshire
wrote:

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.

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.

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.
---
Jay (remove dashes for legal email address)

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



---
Regards,
Norman

On Sun, 3 Jun 2007 13:29:18 +0100, "Norman Jones"
wrote:

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

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.
---
Jay (remove dashes for legal email address)

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.
--
Cheers,
Shane Devenshire


"Jay Somerset" wrote:

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,
---
Jay (remove dashes for legal email address)