Cant find Macro in read only
 

I have a spreadsheet with a macro which normally works fine, the
spreadsheet is stored on a shared drive and whenever my colleague opens
the file at the same time as me (in read only mode) he gets an error
message stating that the macro cant be found.

Any help would be appreciated. (Appologies if this something simple, I
not very good with this excel thingy !).