jkp-ads.com Newsletter for Jul/Aug 2016
Handling problems installing Excel add-ins
Recently I've been receiving reports by people who have downloaded one or more of my free Excel Utilities.
The issues reported vary from not being able to open the files to Excel opening when a file is double-clicked, but the file being ignored by Excel without any error message.
The root cause for all the issues is that the downloaded files have been marked as "Blocked" by Windows. Unblocking these files is relatively simple and involves these steps:
1. Right-click the file in question and select "Properties":
2. Click the Unblock button (in Windows 10 this is a checkbox):
This site shows a method to unblock a series of files with one simple Powershell script:
The Excel VBA Masterclass; Register now!
This in-house training covering advanced VBA subjects such as Error handling, Userform design, Class modules and etcetera has been opened for registration. So if you would like to learn VBA from the master, make sure you register soon!