Disable EPM SAVE button

[Former Member]

Hi - is there a simple VBA code to disable the save button in EPM ribbon, for a specific template.

I have my own custom 'svae' button and i would like to disable the standard save function in EPM.

BR-Hassan

[former_member186338]

Please look on my code here: Disable the Refresh and Save Data tab in excel ... | SCN

[former_member186338]

P.S. Another option is to customize EPM ribbon based on help: 43 Ribbon Extensibility

[Former Member]

which statement from your code?

this?

Public Sub MySave()

    blnMySave = True

    blnMyRef = True

    epm.SaveAndRefreshWorksheetData

    blnMySave = False

    blnMyRef = False

    MsgBox "Saved"

End Sub

[former_member186338]

Sorry, don't copy/paste code without understanding!!!! Ask somebody with VBA experience!

[Former Member]

Hi Hassan

Refer this thread for disabling Save button...https://scn.sap.com/thread/3512570. It has Refresh disable code too...will have to segregate it.

Regards,

JP

[former_member186338]

Please, provide your code

[Former Member]

......Unfortunately I don't! You have provided such a good solution....why not use that...