Skip to Content

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

How to use macros in BPC 10

Hi Experts ,

I am trying to use macros to refresh the workbook on  button click, but it is throwing error Run Time Error '1004' "Can not run the macro refresh.The macro may not be available in this workbook or all macros may be disable "

I am using this simple script in VB Module:

Sub Test_Refresh()

Application.Run "Refresh"

End Sub

and assigning this Test_Refresh Macro on button.Even I am not able to use any other macros of BPC 10.I have already enabled macros in Excel option but not able to resolve this issue .

Please suggest me some solution .

Regards,

Sonam Gupta

Former Member

Helpful Answer

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