Ribbon info for Power Query to disable visibility using VBA

sfsouter

New member
Joined
Aug 29, 2016
Messages
2
Reaction score
0
Points
0
Hi,

I've found some info with using VBA to hide the standard ribbon tabs. In my case I want to hide the Power Query and Power Pivot ribbon tabs to general users to ensure security of the source data before eliminating sensitive fields in power query.

Can anyone help with some VBA code to hide these tabs?

Thank you,
Scott
 
Ken, do you happen to have some input on what the XML code looks like for the Power Query Ribbon? I've come across some code examples for how to make copies of the standard ribbon tabs, but no info on how to deal with add-on tabs like Power Query and Power Pivot. I'd like to hide these tabs from a normal user if possible using VBA.
 
Back
Top