macros disappearing - Word 2019 for Mac

Anonymous
2019-08-21T18:34:26+00:00

When I create macros in the 2019 version of Word for Mac as a way of opening frequently used files, the macros work immediately after I create them, but then anywhere from a few minutes to a day later I get the following error message: "Sorry, we can't find your file.  Was it moved renamed or deleted."  I didn't have this problem with the previous version of Word for Mac or any of the earlier versions of Word I used from back to about the late 1980s, tho those were for Windows-based PCs.

Does anyone have any idea what's causing this problem and how to fix it?

FYI, I'm creating the macros the way I always did, clicking on Tools, then Macros, then Record Macro, then entering in the Keyboard Shortcut box the keys I want to use, then opening the file I want to create access to, then going back to Tools and clicking Macros and End Recording.

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

53 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134.1K Reputation points MVP
    2019-11-20T22:14:38+00:00

    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

    Was this answer helpful?

    0 comments
  2. Anonymous
    2019-11-20T01:51:26+00:00

    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.

    Was this answer helpful?

    0 comments
  3. Jim G 134.1K Reputation points MVP
    2019-11-19T17:55:33+00:00

    Hi Richard,

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

    Was this answer helpful?

    0 comments