We have an macro-enabled excel spreadsheet that is uploaded to the sharepoint drive.
However, it is not able to be 'shared'. Once a user goes in, when an another user attempts to go in, they get a pop up message asking whether they want to 'read' the file only. They are not able to enter the file to have edit access.
Note: We're using the 'open in desktop' option b/c the cloud excel version does not allow macros.