software

Hello all,

Is there any way to specifically set shortcut keys to buttons
(programmatically or by tweaking the registry even)? I would like to
set Excel's quot;Format Painterquot;
and quot;Centerquot; buttons to the same key combos as Word's (Ctrl Shift
C) and (Ctrl E).

Unfortunately, Excel isn't as resilient as Word when it comes to
assigning hot key combos (for those that don't know, please check out
this pictu
home.att.net/~ctbarbarin/file...e_keyboard.jpg). Word
lists every command, what the command does, and all key combos already
assigned to it and allows you to add new key combos to existing ones.

FYI: I'm using MS Word amp; Excel 2002 SP3 (MS Office XP SP3)

Thanks for any help anyone can provide,

Conan Kelly
Hi Conon,
Not sure but are you trying to apply the painter several times.i

Paintbrush (quot;Format Painterquot;) can be applied multiple times by double-clicking, and
turned off by clicking on any toolbar button. The large plus next to the cursor is
probably a tip-off of this feature.
www.mvps.org/dmcritchie/excel...tm#painter.htm

For a macro see ...
Pasting Formats, as in Format Painter (#painter)
www.mvps.org/dmcritchie/excel/paste.htm#painter

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

quot;Conan Kellyquot; lt;CTBarbarin at msn dot comgt; wrote in message ...
gt; Hello all,
gt;
gt; Is there any way to specifically set shortcut keys to buttons
gt; (programmatically or by tweaking the registry even)? I would like to
gt; set Excel's quot;Format Painterquot;
gt; and quot;Centerquot; buttons to the same key combos as Word's (Ctrl Shift
gt; C) and (Ctrl E).
gt;
gt; Unfortunately, Excel isn't as resilient as Word when it comes to
gt; assigning hot key combos (for those that don't know, please check out
gt; this pictu
gt; home.att.net/~ctbarbarin/file...e_keyboard.jpg). Word
gt; lists every command, what the command does, and all key combos already
gt; assigned to it and allows you to add new key combos to existing ones.
gt;
gt; FYI: I'm using MS Word amp; Excel 2002 SP3 (MS Office XP SP3)
gt;
gt; Thanks for any help anyone can provide,
gt;
gt; Conan Kelly
gt;
gt;
David,

Thanks for the reply. What I want to do is assign key combos to
existing commands that I use often. I don't want to create new macros
doing the same thing that existing commands/buttons already do.

Also, as far as I can tell, I can only assign key combos during
recording of a macro. A lot of the macros I create, I do it from
scratch. I hardly ever record macros. The only time I record macros
is to get code samples to use in macros I'm developing.

Another thing, what if I record a macro (we'll call it Macro1) and
assign a key combo to it at the time (say Ctrl Shift P). Then
later on, I decide to change the name of the macro (to
ListUniqueValues). Will Excel recognize the name change? In other
words, every time I press Ctrl Shift P, will Excel try to run
Macro1 (which may not exist anymore or be a different macro) or will
it know to run ListUniqueValues?

When assigning key combos at recording time, it looks like the combo
has to include Ctrl and can not include Alt. That would be okay for
the two commands that I want to assign hot keys to, but it would be
nice to have a little more flexibility for other stuff.

What if I have already assigned a key combo to a macro and then
realize that it might be more meaningful for another macro or that a
different key combo would be more meaningful for this macro (I want to
reassign it)? Can it be reassigned?

Once again, thanks for all of your help,

Conan

quot;David McRitchiequot; gt; wrote in message
...
gt; Hi Conon,
gt; Not sure but are you trying to apply the painter several times.i
gt;
gt; Paintbrush (quot;Format Painterquot;) can be applied multiple times by
gt; double-clicking, and
gt; turned off by clicking on any toolbar button. The large plus next
gt; to the cursor is
gt; probably a tip-off of this feature.
gt; www.mvps.org/dmcritchie/excel...tm#painter.htm
gt;
gt; For a macro see ...
gt; Pasting Formats, as in Format Painter (#painter)
gt; www.mvps.org/dmcritchie/excel/paste.htm#painter
gt;
gt; ---
gt; HTH,
gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt;
gt; quot;Conan Kellyquot; lt;CTBarbarin at msn dot comgt; wrote in message
gt; ...
gt;gt; Hello all,
gt;gt;
gt;gt; Is there any way to specifically set shortcut keys to buttons
gt;gt; (programmatically or by tweaking the registry even)? I would like
gt;gt; to
gt;gt; set Excel's quot;Format Painterquot;
gt;gt; and quot;Centerquot; buttons to the same key combos as Word's (Ctrl Shift
gt;gt;
gt;gt; C) and (Ctrl E).
gt;gt;
gt;gt; Unfortunately, Excel isn't as resilient as Word when it comes to
gt;gt; assigning hot key combos (for those that don't know, please check
gt;gt; out
gt;gt; this pictu
gt;gt; home.att.net/~ctbarbarin/file...e_keyboard.jpg).
gt;gt; Word
gt;gt; lists every command, what the command does, and all key combos
gt;gt; already
gt;gt; assigned to it and allows you to add new key combos to existing
gt;gt; ones.
gt;gt;
gt;gt; FYI: I'm using MS Word amp; Excel 2002 SP3 (MS Office XP SP3)
gt;gt;
gt;gt; Thanks for any help anyone can provide,
gt;gt;
gt;gt; Conan Kelly
gt;gt;
gt;gt;
gt;
gt;