Adding commands to QA toolbar in 2019?

[welshgasman]

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 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?

TIA

 

[Micron]

No idea where your procedures are, so maybe what you're looking for is out of scope? Unless they are declared as Public, they are Private (IIRC). Or the one you don't see in the list is not in a standard module? Just shooting out possibilities here.

 

[welshgasman]

Hi Micron,
None are declared Public, just start with Sub. Those that are displayed are exactly the same.

I have now asked at Microsoft Community as was not getting any response here, which is unusual I must admit.

 

[FormR]

Hi, you can't add macros that have input parameters (even optional ones).

 

[welshgasman]

Hi, you can't add macros that have input parameters (even optional ones).

Thank you FormR,

Hmm, and this is meant to be progress.
2007 had no issue. I must admit I rarely used a parameter, if I did it would be from the immediate window or another block of VBA, hence the default of current workbook.
I am on another computer at present. I will remove and try again when I get back on it, and also check if the others have the same problem.

 

[FormR]

2007 had no issue

I don't believe you have ever been able to add a macro that requires a parameter to the QAT as there isn't a mechanism to pass said parameter.

 

[welshgasman]

I don't believe you have ever been able to add a macro that requires a parameter to the QAT as there isn't a mechanism to pass said parameter.

Hmm, well it seems we might be both correct.
I looked on this computer and this version did not have the parameter. So I added it, saved and then went to add to QAT, and sure enough, It was not visible, yet the original icon was still in the QAT and that still works. So if you wanted to do this for some reason (mine has evolved over the years) that would be the way.

Thank you for the solution though. When I get back on my laptop, I expect to find this is the cause, and will report back.

 

[welshgasman]

@FormR , you hit the nail on the head. I can only assume that I modified the macro after it was added to the QAT.
It now works fine on the QAT and if you readd the parameter (must be optional of course) can use it elsewhere if needed.

Thanks again for pinpointing the issue. I will now check all my other macros.