A macro virus is a type of computer virus that could be stored in macros within an Microsoft Office file (such as a document, presentation, workbook, or template), or within any ActiveX control, COM add-in, or Office add-in. We refer to macros, ActiveX controls, and add-ins as "Active content".
For your protection, Office doesn't run active content automatically unless the file has been marked as a trusted document or opened from a trusted location.
For all other files containing a macro or other active content you'll usually see a message that looks like this:
Do not select Enable Content unless you're certain that you know exactly what that active content does, even if the file appears to come from a person or organization that you trust.
Note: Opening a file with macros disabled might limit the file's expected functionality.
Office can't scan files or locations to find and delete macro viruses, however all modern anti-malware software - like Microsoft Defender Antivirus - should be able to detect, and block, known macro viruses.