Disable the QAT on the Excel ribbon

I am creating a 'director style' Excel application, which of course has it's own customised ribbon tabs, groups and controls.

What I want to know is how can you disable (i.e. completly hide) the QAT (Quick Access Toolbar) or at the very least only show the buttons you nominate AND, most importantly, remove the option for the user to add their own controls (customise) via the down arrow at the end of the QAT ?

According to to the below EE question' answers, when you use 'startFromScratch' (which of course I am using) the QAT is automatically emptied. It is not. In fact I can see old icon customizations such as 'save','print','open'. I have tried creating ribbonx for QAT '<sharedControls>' and '<documentControls>' but to no avail.
EE article on changing the QAT

Please can someone enlighten me becuase looking on the web has revealed no real answers (not that there is much on QAT).
LVL 3
AL_XResearchAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rory ArchibaldCommented:
startFromScratch should empty (and disable) the QAT. Certainly does for me.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AL_XResearchAuthor Commented:
Ahh, I was editing the wrong file. The curse of multiple development copies. startFromScratch does clear the QAT and disable the customisation.

It does leave the 'customisation drop-down' arrow behind though, is there any way of removing that ? Say with one of the <command> statements ?
0
Rory ArchibaldCommented:
Not that I know of. (it's only cosmetic)
0
AL_XResearchAuthor Commented:
Well you can't have everything can you !
0
AL_XResearchAuthor Commented:
They question did not really need to be posed since I had the right solution but had mistakenly mixed up the files and believed it was not working.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.