Gasman
Enthusiastic Amateur
- Local time
- Today, 20:40
- Joined
- Sep 21, 2011
- Messages
- 17,351
Hi all,
Just updated to Office 2019. Already regret doing so TBH.
I have found out how to add commands to the QA toolbar in Excel, (same as in 2007), however a good few are not presented, so as to be able to add them?
I have a Personal.xlsb with commands I can use anywhere. One is a macro called BackupFile which will back up the current workbook.
However that is not shown?, Yet some are available and I have added to the QA as you can see.
How do I get to find the 'missing' macroes please?
I have also asked at
www.mrexcel.com
TIA
Just updated to Office 2019. Already regret doing so TBH.

I have found out how to add commands to the QA toolbar in Excel, (same as in 2007), however a good few are not presented, so as to be able to add them?
I have a Personal.xlsb with commands I can use anywhere. One is a macro called BackupFile which will back up the current workbook.
However that is not shown?, Yet some are available and I have added to the QA as you can see.
How do I get to find the 'missing' macroes please?
I have also asked at

[Solved] Add macros to Excel QAT - Microsoft Q&A
Hi all, This has got me stumped. I installed Office 2019. previously I was using 2007. I know how to add macros etc to the QAT. in 2019 it is the same method as in 2007. However in 2019 a lot of my macros from my personal.xlsb file are not even showing…
answers.microsoft.com

Adding commands to QA toolbar in 2019?
Hi all, Just bit the bullet and installed Offfice 2019 in place of 2007. I have found out how to add commands to the QA toolbar in Excel, however a good few are not presented, so as to be able to add them? I have a Personal.xlsb with commands I can use anywhere. One is a macro called BackupFile...
TIA