Macros not working when a workbook is opened by multiple users

When second user opens a workbook (in read only) because another user has it opened, the macros for the second user do not work. Does anyone know of a work around for this?

Thanks