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:
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 .