Basically, macros are always enabled whenever you share the macro-enabled excel files. But it has limited access and cannot perform tasks such where the security is a concern like hide/unhide, protect/unprotect, delete or format cells or sheets. Also one cannot define macros when file is shared. Macros which involve setting formulae, editing values might work, in general, all calculation operations would work to an extent.

Hope, this answers your question.