max number of macros

H

hey

When I go to run a new macro, the short cut key only lets me put in letters, limiting me 26 max. Is there a way to get more then 26macros per workbook

Thanks
 
P

Peo Sjoblom

You can use the shift key as well that will give you 52 different short
cuts,
however why would you want to do that?

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom


hey said:
When I go to run a new macro, the short cut key only lets me put in
Click to expand...
letters, limiting me 26 max. Is there a way to get more then 26macros per
workbook?
 
K

kkknie

You can have as many as you want, but can only assign to 52 differen
letters (you can use both upper and lower cases). If you don't assig
to a shortcut, you must run from the Macro menu or assign to a contro
(like a command button).
 
D

Dave Peterson

If you want a pretty neat way to build access to your macros, you could use
John Walkenbach's MenuMaker program. It adds an option to the worksheet
menubar. It's really pretty neat and easy to use/update.

http://j-walk.com/ss/excel/tips/tip53.htm

(I'd stay away from using some of excel's builtin shortcut keys, too. Ctrl-x,
ctrl-v, ctrl-c for example.)
 
Top