Skip to Content

Help on Epm add-in?

Hello All,

How i can disable 'Refresh' and 'Save data' buttons from EPM ribbon?

What are the possible ways to do it??

Thanks,

Naidu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 13, 2015 at 01:15 PM

    You want to replace the mentioned buttons with custom VBA buttons on your sheet? Or what?

    Save data will be active only for input form... Refresh can be blocked by VBA...

    Vadim

    Add comment
    10|10000 characters needed characters exceeded

    • Yes, that's what I am talking about. If you have the option "Use as input form" unchecked the correct assumption is that you can't save any data 😊 And Save button is disabled. The bug is that the functions like SaveWorksheetData, SaveAndRefreshWorksheetData,... are not checking this option!

      By the way, if you use VBA to create custom Send button - it's easy to disable standard Refresh and Send using BEFORE_REFRESH and BEFORE_SEND events (with some flag set in your custom button code). And this method is correct and will be supported later.

      Vadim

      P.S. Look on my code here: