Collaborating and sharing excel data in excel on local server

Hi I want to make a workbook which contains macro and want it to be used by multiple users and workbook will be placed at a local server.