M
MEAGAIN
HOW DO I GET MORE THEN 27 MACROS IN A FILE? IT IS LIMITING ME TO THE 27 LETTERS OF THE ALPHABET
THANKS
THANKS
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
1. Typing in all CAPS is considered shouting and rude.
2. What are you talking about? You can use A1, AAAAAAA, etc. to name macros.
If shortcuts, you can use combinations of keys and letters.
BTW, last I heard, there are 26 letters in the English alphabet.
2. What are you talking about? You can use A1, AAAAAAA, etc. to name macros.
If shortcuts, you can use combinations of keys and letters.
BTW, last I heard, there are 26 letters in the English alphabet.
G
Gord Dibben
If this is for real........and I have some doubt!
I have a workbook(add-in) with more than 200 macros in place. I'm sure there
are workbooks with many more than that.
Don't name your macros A, B, C etc.
In addition, which alphabet are you using that has 27 letters?
Gord Dibben Excel MVP
I have a workbook(add-in) with more than 200 macros in place. I'm sure there
are workbooks with many more than that.
Don't name your macros A, B, C etc.
In addition, which alphabet are you using that has 27 letters?
Gord Dibben Excel MVP
D
Debra Dalgleish
You can also use the Shift key when you assign the letter for the
shortcut. So, you could have one macro that runs with Ctrl+a and one
that runs with Ctrl+Shift+a
If you run out of letters, you can add toolbar buttons or worksheet
buttons to run the macros.
Or, choose Tools>Macro>Macros, select a macro, and click Run
shortcut. So, you could have one macro that runs with Ctrl+a and one
that runs with Ctrl+Shift+a
If you run out of letters, you can add toolbar buttons or worksheet
buttons to run the macros.
Or, choose Tools>Macro>Macros, select a macro, and click Run
D
Don Guillett
or alt F8