Macros are not supported on the Excel app for iPad. This is because the Excel app for iPad is designed to be a lightweight version of Excel, and it does not have the full functionality of the desktop version of Excel.
If you need to use macros on your spreadsheets, you will need to use the desktop version of Excel on a Windows or Mac computer.