Home › Discussions › Questions & Answers › Excel VBA Failure due to Protected View
Customer · · Questions & Answers · 5 replies
When opening a Blitz Upload XLSM workbook, Excel shows ‘Run-time error ‘1004’: Method ‘Onkey’ of object ‘_Application’ failed. There is also a security warning that the file is blocked.
This error occurs because the Protected View is enabled in Excel, and the EBS URL from which the file was downloaded is not recognized as a trusted site. The VBA code cannot execute.
What is the primary resolution to this issue?
You must add the EBS URL to the trusted sites via Windows ‘Internet Options’ configuration. Remember to close all opened Excel workbooks for the changes to take effect.
If we cannot change global trusted sites, what Excel setting can serve as a workaround?
A client-side workaround is to open Excel File > Options > Trust Center > Trust Center Settings > Trusted Locations, and add the download location where the Blitz output files are saved.
Sign in with LinkedIn or Google to take part.
