Hi all,

I seem to be having a problem with opening some files using vba code. Whenever I run the code and the file tries to open I get a run time error and the code stops. When I opened the file up manually I noticed it opens in protected view with the red bar accross the top which when I investiagted further I found out was due to a validation error. My question is how can I get these files to open through VB?

I have tried going into the trust centre settings and changing the protected view options so they are all disabled, but this makes no difference and I suspexct they are overwritten somehow by our IT department. I've also tried adding the file location as trusted but this is in breech of my security settings set by our IT department again.

Appreciate any help.

Rob