Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

VBA Upon Changing a Member


I am trying to have some code run after any type of refresh happens, and I can't get it to activate the code when I change a member in the axis.

Just for simplicity:

This activates if you push the Refresh button.

(in module)


Rows("12:12").RowHeight = 9

End Sub

This activates if you change the context member.

(in module)


Rows("12:12").RowHeight = 9

End Sub

This activates if you use member recognition and type over the cell (so the cell physically changes)

(in the Sheet)

Private Sub Worksheet_Change(ByVal target As Range)

If Not Intersect(target, Range("$A$4")) Is Nothing Then

Rows("12:12").RowHeight = 9

End If

End Sub

However, if you just double click in to a member of the page axis and select a new member with the member selector box, it doesn't activate. I tried looking into the EPM Documentation, but couldn't find a solution to this, and everything I tried has failed.

Any ideas on how I might accomplish this?



(I am using BPC 10.0 NW, EPM SP20)


Helpful Answer

Not what you were looking for? View more on this topic or Ask a question