It was considered too easy for recipients of malicious content to click that magic Enable Content button and get themselves into hot water. Microsoft observed that most users automatically trusted whoever was sending the file and sometimes dubious techniques were used by naughty people trying to trick you into trusting them.

That appeared in the message bar below the ribbon when you opened the file, like this: Prior to this change, if you received a file from the Internet via an email or a website download link, you’d be explicitly asked to Enable Content, assuming you trusted whoever was providing you with the file.

A change to VBA security that Microsoft rolled out at the end of March 2022 tweaks the process required by Windows users to gain access to this active content.

And sometimes you need to share that VBA solution with colleagues and clients, via the Internet. You can do some really cool things in Microsoft Office with just a few lines of Visual Basic for Applications (VBA) – from creating your own custom formula in Excel to correcting branded content in PowerPoint to merging address data for a mail campaign in Word.

Excel mac developer tab macros