Prevent from using Pivot Table RefreshAll

[James006]

Hi,

Because of a series of rather "sensitive" Pivot Tables (which, by the way, can get updated thanks to specific individual Event macros ) , I am looking for a way to prevent users from launching the general RefreshAll command for all the Pivot Tables ?

Thanks for your assistance.

 

[James006]

Hi again,

All credit goes to Andy Pope

< customUI  xmlns="http://schemas.microsoft.com/office/2006/01/customui" >
    < commands >
        < command 
            enabled="false"
            idMso="RefreshAll"/ >
    < /commands >
< /customUI >

HTH