A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Macros cannot be viewed or edited in shared workbooks, but macros created in the workbook when it is not shared can be run when it is shared. So I see no reason why your existing macro should not work