I have OneDrive and have never had any problem running macros in files saved to it.

How are you accessing these files - via your computer desktop or dirrectly from the cloud?