Hey Arun,
Well, if you're asking how to share workbooks then go through this tutorial. Its pretty simple. There's an option to share within Review tab. Also I have attached a sample workbook with sharing ON - where my macro still works with multiple users updating it at the same time - as I said until you perform certain operations which make changes the structure of the excel file.
Let me know for any confusions.
P.S. To see the code section you'll have to disable the share.
Bookmarks