Macro from Excel 2011 Mac to Office 365

Copper Contributor

Hello, since upgrading to Excel 2019 for Mac I receive the following message when opening a file that has a macro (Macro was saved to Personal Macro Workbook 2011). I noticed that Office 365 Excel maybe saving to macros to a new file called "Personal.xlsb" file.

 

This workbook contains links to one or more external sources that could be unsafe.

 

Can anyone advise how to correct this. I have no links to other workbooks in these files.

Do macros created in Excel for Mac 2011 need to be updated for use in Office 365 for Mac?

 

Lastly, how can I delete my macros created on Excel for Mac 2011. I only have a few macro and would like to recreate in Office 365 Ecel Mac.

 

Thanks

 

 

0 Replies