Register
Log In
Unanswered
Home
Dashboards
Power BI
Power Query
April 21, 2015
Offline
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!
Dashboards
June 25, 2016
Offline
Hi Frans
As far as I am aware, Excel will allocate the ALT 1 to 9, ALT 01 to 09 and then 0A, 0B, 0C etc automatically to the shortcuts/macros you added to the QAT.
So there can be more than 10 buttons.
Refer attachment.
Sunny
Dashboards
Power BI
Power Query
April 21, 2015
Offline
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?
Dashboards
June 25, 2016
Offline
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
Dashboards
Power BI
Power Query
April 21, 2015
Offline
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.
Most Users Ever Online: 57
Currently Online: Max Neumann
10 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Sethu nath
Jose Alvarado
James Villapudua
Sheri O'Connor
Noreen Anagnos
Connie DeMercurio
Shanna Steinberg
Holly Seamons
Mark Cooper
David Matanana
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
