max number of macros

[Guest]

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

 

[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

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?

 

[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).

 

[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.)