MACROS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HOW DO I GET MORE THEN 27 MACROS IN A FILE? IT IS LIMITING ME TO THE 27 LETTERS OF THE ALPHABET
THANKS
 
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.
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to type each letter of the alphabet automatically in a specific color in Word? 0
27inc high lumen screen recommendation for Australian Client 0
Excel How to add numbers in same cell? 2
What a day 9
Dynamic range 2
Complex Counter 1
need help in formula 10
How do count blank cells between some period of time? 4

Back
Top