macros disappearing - Word 2019 for Mac

It occurred to me that the behavior you're seeing can happen if a macro isn't working with the worksheet that it thinks it is working on.

For example, your macro code might say something like:

With Activesheet

do something

End with

When you wrote or recorded the Macro you were working on one worksheet. But later, for some reason that particular worksheet isn't the one that is currently the active worksheet.

A better way to do it when making your macro is to specify exactly on which worksheet you want the action to happen

    With Sheets("Sheet2")

     do something

    End With

Though I've given attention to all your suggestions, I don't recall one about code.  In fact, I don't even know what code refers to.  The problem with macros only arose when I had to get a new Office Suite in October of last year for my new iMac, as my old Office Suite was no longer supported.  So the problem seems to be in Office Suite for Mac not in anything in my computer.  

If code refers to how I create macros, I create them exactly as I did when I had the earlier version of Office Suite.

Hi Richard,

Did you give any consideration to my suggestion that your code might not be handling windows as effectively as it could?

It's been about a month now since I sent my feedback and I've received no response of any kind.  This isn't the first time I've experienced this.  I called the problem you've been trying to help me with to the attention of various offices of the company at various times beginning over a year a go.  I very rarely received any response and the problem still hadn't been dealt with last time I checked.

Microsoft's unresponsiveness is disturbing.  I'm gradually phasing out of Office Suite and eventually plan on no longer using it, or any other Microsoft product.  The company seems to have been able to get away with its customers be damned attitude so far, but eventually, I hope, it will pay a price, perhaps as a result of the growing disillusionment of the public and politicians with the monopolistic positions of the tech giants.

Thank you for your efforts.  They've been an oasis in the desert of Microsoft's unresponsiveness.  However, the problem still remains, or at least did last time I checked, which was a few weeks ago.

Hi

I just re-read your Sept 27 reply and it dawned on me that the macros may not be written to accommodate multiple windows being open simultaneously.

For example, the code may think you have a particular worksheet as the active worksheet, but perhaps you clicked into a different worksheet or the code activated a different worksheet from what the command is currently expecting. It's risky to write code using ActiveWorksheet. Your code should specify exactly which worksheet it wants to perform operations on.