Use a shared workbook to collaborate - Support

You can also record shared workbook operations into a macro stored in another nonshared workbook. Add or change Microsoft Excel 4 dialog sheets. Change ...

support.office.com