Macros can run in shared workbooks.

But some features are unavailable in shared workbooks--whether you try to do
them manually or via code.

So the workaround is to not to use those features (or try to find a different
way to do them) or not to share the workbook.

But I think you'll need to share the feature that's not working to get any
specific suggestion (either a workaround or just a "that won't work" response).

Very Basic User wrote:

Hello,

I currently have a shift note file with multiple macros doing things like
making merged cells grow with content, and auto saving to new tabs while
clearning out the master as the sheet is filled in. My problem is that I have
two to three people (Operations, Quality, Safety) that could be filling in
information at any given time during a shift. When I try to share the file,
the macros stop working. Is there any workaround this issue?
--
Thank you for your time!
John

--

Dave Peterson