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)