Disabling 'Refresh' Button in Excel EPM add-in

[Former Member]

Hi Experts,

I have a Refresh command button on my EPM 10 report which is using a VB macro to refresh the complete workbook data.

I need to protect user from accidently clicking on the 'Refresh' button under the EPM ribbon, and refresh just the worksheet data. I would thus want to disable the 'Refresh' option from the EPM Ribbon.

Is there a way of disabling/greying out the Refresh button under the EPM ribbon in EPM addin?

I am working on Version 10.0 SP 22 Patch 2 .NET 4

Thanks in advance,

Rupali

[former_member186338]

Yes, you can use my simple code provided in the link in the previous answer.

Or - more complex way: please read EPM help: 42.2 Ribbon Extensions: Advanced Method

Vadim

[Former Member]

Hi Rupali,

As far as i know there is no direct method to disable the epm refresh and save button but through VBA code you can disable it.

Please take a look at below thread may be useful for you.

Disable the Refresh and Save Data tab in excel ... | SCN

Hope this will solve your problem.