Microsoft says the suspension of Office blocking internet macros is only temporary and that it will provide an update in a few weeks.

But Microsoft unexpectedly has reinstated VBA macros within Office after “feedback,” according to reports. In February, Microsoft took action to block Visual Basic (VBA) macros by default.

You can fix VBA Runtime Error 1004 in Excel Macro, like document not found, reference isn't valid, Paste method of worksheet class failed, etc, by following this post.

Microsoft has announced it will begin blocking Visual Basic for Applications (VBA) macros obtained from the public internet by default across five of its most used Office apps from April 2022, in ...