can i edit the share excel file when more then 1 person open it

i have 1 share excel file, but when my file was open by others person, i only can open in read only cannot do any edit, so can i have another way to edit when open file more then 1 person.

if i using the share workbook function but my all marco cannot be use.

do anybody have the solution for it