Although you can't work with macros in Excel Online, you can open a workbook that contains macros—though you won't be able to see the macros. You can edit the worksheets and save a workbook containing macros in Excel Online. The macros will remain in the workbook, and you open the workbook in the Excel desktop application to view and edit the macros.
To edit a macro:
If you have the Excel desktop application, you can use it to work with macros. Above the ribbon, click Edit in Excel and follow the steps in Create, run, edit, or delete a macro.
To delete a macro:
If you open a workbook that contains macros, you won't see any messages from Excel Online. If you know that the workbook contains macros and you need to remove them, this must be done in the Excel desktop application. Follow the steps in Create, run, edit, or delete a macro.
Did you know?
If you don't have an Office 365 subscription, or the latest version of Excel, try it now for free: