Custom Ribbon Items dependant on User

[sharky12345]

Guys,

Firstly, wasn't sure if this needed to be posted here or the general forum, so apologies if it's the wrong one but as it's related to Excel I guessed here would be ok....

I've been using the Custom UI Editor to add my own Ribbon menu items - this has been successful but now I need to know if I can hide or disable items depending on a User access level within the workbook itself.

If it is possible, would someone kindly point me towards a resource that can show me how?

 

[Dryver14]

There is probably another option after this step but at the top of the QAT setup you can select either general or this workbook, thos allows you to select it so it is not available unless you do so

 

[Dryver14]

So looking into this further create the customised QAT and then export it. you can send that file to the relevant people and whenever they open a spreadsheet that customized toolbar is available in their QAT dropdown