Macro-enabled workbook problems

[helplessnoobatexcel]

Hi All, so I have a created a macro enabled password protected workbook that requires a user login form when users open the workbook. Problem is how to share the macro-enabled workbook with other users to allow them to work on their respective sheets simultaneously at the same time. Any ideas on how I can achieve this? Thanks!!