I hope this could be the problem that the macros are not enabled automatically in your workbook
Please perform the below step:
Go to Tools —->Macros—–>Security—-> Choose medium & press ok
Close & reopen the workbook.
Click enable macros in the dialogbox when you open the Excel sheet.
Please post more information reg this issue.