Microsoft blocking VBA in downloaded files (or do they?)

Microsoft announced earlier this year that they would be automatically blocking macros in downloaded Office files (as a security measure), then recently they said they wouldn’t, then yesterday they said they would, but not right now.

For more details, plus numerous comments see:
Microsoft: Roll back of VBA macro block in Office is only temporary

For more details about what can be done about it, including details of how to add security certificates without spending a fortune see:
https://www.computerworld.com/article/3666951/nows-the-time-to-prep-for-microsofts-excel-macro-crackdown.html

How this will affect files downloaded from here, I am not sure, but if you have trouble using the VBA code in any of the download files, please let me know.

As for my opinion on how Microsoft have handled the whole thing, I’m appalled:

This entry was posted in Computing - general, Excel, UDFs, VBA and tagged , , . Bookmark the permalink.

1 Response to Microsoft blocking VBA in downloaded files (or do they?)

  1. Larry Schuster says:

    Without getting into discussions about the use and risks of self-certification, another possible option until MS sorts this thing out is to use Abylonsoft SelfCert (https://www.abylonsoft.com/selfcert/)

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.