Generally you can't able to Merge cells in a shared workbook. Open a New
workbook and save it then make the file in sharing mode and see whether you
can able to access the merge cell option? The answer is No.

When we can't able to do it manually then how the macro can merge the cells
when the file is in sharing mode.

If this post helps, Click Yes!

--------------------
(MS-Exl-Learner)
--------------------



"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