VIP
April 21, 2015
Somebody asked me this question, and after some investigation I couldn't find a solution, so that's why I'm here with the question.
She made some buttons with some actions on the quick access toolbar.
First with Alt-1, second Alt-2, etc.
After the nine she wanted some more and made some with Alt-01, Alt-02 etc.
But the zero is ignored and doesn't work as it seems. So there only seem to be 10 buttons available this way.
Is that correct? Or is there another way to make this work?
It makes no difference with normal numbers or keypad numbers and such.
Thanks!
VIP
Trusted Members
June 25, 2016
VIP
April 21, 2015
Thanks Sunny for this reply!
So we think it's possible. What can be the fault, because it doesn't seem to work? As far as I know now there are little macro's behind the buttons, who color some rows and such. So no rocket science. But it seems something interferes? Where do we have to look? Any ideas?
VIP
Trusted Members
June 25, 2016
Hi Frans
I have no idea why yours didn't work
I have created 15 buttons and did encounter any problem running the macros using the ALT keys.
When you hold the ALT key only, what was displayed on the buttons on the QAT? It may give you some clues.
Does it look something like the attachment I gave you?
Sunny
VIP
April 21, 2015
First I didn't do it myself, it's a question somebody else asked me.
And yes: I think the way it looks is the same (see attachment).
I suggested updating to the most recent versions of the Windows and Excel versions.
And as I understood it's someone in Belgium, they work there with a AZERTY keyboard. Maybe there is something wrong with that setting.
I now got the different quick buttons and I will try it myself on my computer and see if that works.
So I'll be back with the result of these investigations. Strange thing this one.
1 Guest(s)