Two views on VBA

First from Microsoft:

Microsoft are continuing their quest to make downloading spreadsheets with macros ever more difficult, and now any downloaded spreadsheet has VBA code disabled by default. Unblocking the code (if you know and trust the source of the file) is quite easy. Find the file in File Explorer, right-click and select Properties, then select “unblock” down the bottom:

If you leave the file blocked however, and try to enable the macros, Microsoft will take you to a page on their website that says:

A potentially dangerous macro has been blocked
Macros can add a lot of functionality to Microsoft 365, but they are often used by people with bad intentions to distribute malware to unsuspecting victims.

Which is fair enough, but then it says:

Macros aren’t required for everyday use like reading or editing a document in Word or using Excel workbooks. In most cases you can do everything you need to do in Microsoft 365 without allowing macros to run.

Which is rather like saying you can do everything you need to do in your car without enabling top gear.

Coincidentally, the same day I had the problem with the download I found a new website dealing with using Excel with VBA for structural engineering design:

Lucas Beattie

where the very first article was:

Full article

This entry was posted in Excel, VBA and tagged , , , . Bookmark the permalink.

2 Responses to Two views on VBA

  1. Thank you so much for the mention! I do wish Microsoft was a little more friendly to VBA. It’s such a useful tool and a lot of fun!


    • dougaj4 says:

      I suspect the problem is the people in charge of developing Excel really don’t appreciate the range of applications it is used for, and why people who are not professional programmers find VBA useful.
      Anyway, keep up the good work with your web site 🙂


Leave a Reply

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

You are commenting using your 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.