SparklyPrincess6969
Registered User.
- Local time
- Today, 05:08
- Joined
- Jun 30, 2014
- Messages
- 15
I am philosophically opposed to disabling "Show All Commands" in Options, because i believe organizations should have a non-hierarchical culture of pervasive trust and transparency that gives every user full opportunity to learn and innovate, and I am also really lazy. 
Nevertheless! my client has a DB with a Custom ribbon that disables everything but the Home tab. However this kind of cripples the users when it comes to a Pivot form they have - as the Design tab is hidden, they can't add new fields or export to Excel or anything. So they need it enabled while having all the others disabled. I was wondering if anyone's ever accomplished something like this before? I don't have much experience writing custom ribbons, and some ideas or maybe an example of something that explicitly enables the Pivot form Design tab.
I attached a screenshot that maybe explains what I'm looking for a bit clearer (NOT the custom ribbon.) Also here's the XML code for the current custom ribbon, the one that disables everything and I am hoping to modify:
Nevertheless! my client has a DB with a Custom ribbon that disables everything but the Home tab. However this kind of cripples the users when it comes to a Pivot form they have - as the Design tab is hidden, they can't add new fields or export to Excel or anything. So they need it enabled while having all the others disabled. I was wondering if anyone's ever accomplished something like this before? I don't have much experience writing custom ribbons, and some ideas or maybe an example of something that explicitly enables the Pivot form Design tab.
I attached a screenshot that maybe explains what I'm looking for a bit clearer (NOT the custom ribbon.) Also here's the XML code for the current custom ribbon, the one that disables everything and I am hoping to modify:
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<commands>
<command idMso="FileNewDatabase" enabled="false"/>
<command idMso="FileCloseDatabase" enabled="false"/>
<command idMso="ApplicationOptionsDialog" enabled="false"/>
<command idMso="FileExit" enabled="false"/>
</commands>
</customUI>