How to add macro on QAT in excel 2007 after reopen

[Leon]

 

[Bob I]

Please use this area to pose your question.

Leon wrote:

 

[Ron de Bruin]

I think this is your problem

http://www.rondebruin.nl/qatbuttonbug.htm

 

[Sands]

Hi

I want to add a macro to the QAT for a single workbook. I can add the macro
to the QAT, change the icon, etc but when I reopen the workbook the macro is
no longer on the QAT.
Please tell me there is a simple workaround for this that doesn't involve
opening zip files and editing xml file etc.
Thanks for any help

 

[Ron de Bruin]

It is a bug and this is the only way to fix it