Share workbook that has macros and VBA

[ApolloCarrierServ]

I have a sales list that I have been working on. It has several macros and VBA to sort and filter data. I am wanting to share this list with another person to be able to update/change information. Is there a way to share my workbook and keep all of the macros and VBA functioning for both people to work on?

 

[jmacleary]

Hi there. It very much depends on what your macros do. They will still be available in a shared workbook, but you wont be able to edit them. This page gives an overview of what isnt available to shared workbooks: https://social.technet.microsoft.co.../common-issues-of-shared-workbook?forum=excel

 

[ApolloCarrierServ]

The macros filter customers information by regions and then automatically move certain customers based on information I select to other pages to organized customer preferences. So it sounds like I'm not going to be able to share the workbook. Is there maybe a way to add a sheet that updates the information from my working sheet to a shared sheet that is automatically updated via onedrive or something?