SAP IBP VBA function raises delete confirmation pop-up

[fabrizio_daros_sys]

Dear all,

I wrote a simple VBA function. I call it via Excel formula (local member) and it looks like:

=CUSTOM_SUM(row(),column(), relative1, relative2)

where relative1 and relative2 are two costant values (e.g. -1 and -2 )

In the VBA code I just sum up two values:

Function CUSTOM_SUM(r As Integer, c As Integer, posS As Integer, posF As Integer) As Double

a = ActiveSheet.Cells(r + posS, c)
b = ActiveSheet.Cells(r + posF, c)
CUSTOM_SUM = a + b

When I refresh the sheet I get a 'delete confirm' pop-up from auto-generated sheet called SAPTempSheetCF.

How can I avoid this confirmation?

Thank you.

[former_member194529]

Hi Fabrizio,

Did you find a solution for your issue? If so, please feel free to share it here.

Best,

Ivan

[fabrizio_daros_sys]

Dear John,

I'm waiting for news from SAP Development Support because they are working on it.

BR, F.

[johnnbc]

Did you get an answer to this? I received this error using EPM with a custom VBA function

[fabrizio_daros_sys]

Dear Ivan,

Thank you for your message.

I didn't find any solution till now. I'm waiting for news from SAP Development Support because they are working on it.

I will share the solution when it will be available.

BR, F.