1004 error in protected view

I have an Excel 2010 template with extensive VBA code which runs without errors when fired up from any location on my laptop. When I test accessing it through my organisation's intranet (it needs to be accessed by around 300 staff), it downloads to the Downloads folder and, when opened from there it is in Protected View and throws a 1004 error in the WorkBook_AfterOpen procedure. Disabling opening in Protected View is not an option. If I then retry to open the file, there is no error.

It may be a timing error as described here:

http://answers.microsoft.com/en-us/o...d-7a6204704d86

I've tried implementing the OnTime method without success. Here is my code:

Please Login or Register  to view this content.

Can anyone help? I'm pretty sure that my code is bug-free as it runs fine when fired up in non-protected view from the desktop. I think that it's a higher-order Excel timing problem.

Thanks in advance

Iain

What is the level of security set for macros on the 300 users PC's.

Run-time error 1004: Method 'OnKey' of Object '_Application' failed

Largely unknown to me but, as the file is downloaded to the Downloads folder, I assume that this folder is not a trusted location on all users' computers. For pretty sensible reasons my organisation will not give Downloads folders a trusted location status. Is there a way to change the downloads folder for this application to some other folder which could be given trusted status?

Norie and Tellm

Thanks for your responses.

I've done a bit more research on this and it seems that it's a known issue in excel 2010. This url gives details:

https://support.microsoft.com/en-us/kb/2745652

The KB article gives some sample code. My questions now are these: can the sample code be implemented as is or does it have to be customised for my own identifiers (workbook name etc); do the open and activate events code in the sample replace the standard Workbook_Open and Workbook_Activate events or do they have to be called explicitly?

Thanks in advance.

Iain

Norie

Any idea how I call this code?

Iain