Hi Samantha, 

Welcome to Box Community and glad to help! 

As of this message, excel macros is not supported in Box. For any product feature request or suggestions, we recommend you post your idea on pulse.box.com for more visibility. Our product team reviews all submissions and will consider whether to include feedback in their product roadmap. 

Thanks for posting! 

You've got to be kidding me.  My excel macros have worked great using Box Sync and now suddenly Box upgrades to allow direct linking to Box without needing Sync and my macros stop working.  Please tell me this has been resolved?  Otherwise Box will become useless as our primary storage tool and I'll need to manually sync files back and forth.

I am having this same issue 360497915707 please help us fix this ASAP

Not sure this helps much, but we have had limited success using Macros on Excel while the file is saved on Box, however, the user is not set up with Co-authoring. We were able to use Macros when accessing via Box Drive, will need to continue testing to find the full capabilities.