VBA code and recent microsoft update

[mickeylove]

Hi,

I store all of our excel documents on Sharepoint and i tried to access them this morning and i am now getting a "blocked content" notification. I have added the sharepoint URL to the list of trusted sites in the excel trust centre but the documents are still showing with blocked content. I can not get the content to unblock without globally unblocking all VBA content which is not a very secure option.

Before this happened i would get the standard notification in excel regarding VBA content if i opened any new workbook. This was a simple request as to whether i trusted the source or not! i then got the usual "always trust this source" request and when i selected YES it was acknowledged as a safe document.

In the excel trust centre there is no longer a way to do this as far as i can see without doing it for ALL excel documents.

Any help would be appreciated

 

[Jon Peltier]

In Windows, you can right-click on a file, choose Properties, then unblock the file in the dialog. I don't know if SharePoint offers the same Properties dialog.