Here's the situation : the excel file should stay in shared drive, currently the setting is not Share Workbook. The issue is only the first person who opens the file has privilege to edit the file, other people have view privilege only.

The file should allow multiple people to edit at the same time, so I make the setting change. But macro code is not viewable if it allows multiple people to edit at the same time. This is not big deal for me, but I would like to know if the file allows multiple people to run macro at the same time?

Thanks.