The subject should summarize the question it's okay if they match, but empty
postings are somewhat of a nuisance, like when is the question going to appear.

To create a shortcut key for a macro
Alt+F8 (Tools, macro, macros), select the macro, options, key in shortcut key.

More information
http://www.mvps.org/dmcritchie/excel...x2k.htm#mykeys

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"bk1803" wrote in message ...