Updating user policies
The set of user profiles for a Share Point Server 2013 farm are stored in the profiles database associated with a User Profile service application.User profiles are also used in server-to-server authentication which allows for servers to access and request resources from one another on behalf of users.I always assumed it was just used so that it didn't scare end users into thinking their PC was about to crash.When I started reading more into improving the efficiency of your code I understood what it was for but how much of an effect does Turning off screen updating will only make a difference to execution time if the code interacts with Excel in a way that causes changes to the screen content.This allows the computer object to read the policy setting and the policy will then work again.As a reminder I stressed back in 2010 that you should never just remove “Authenticated Users” from your GPO’s and that you should instead simply remove the “Apply” permission for the group.See the Applies To tag at the top of each article to find out which version of Share Point an article applies to.
Use this code template as a starting point (the error handler ensures that these properties are turned back on at the end of the sub, even if it errors) Sub Your Sub() On Error Go To EH Application. Select Next i 'get results results = "Screen Updating not disabled: " & Format(Time - start Time, "hh:mm:ss") & " seconds" start Time = Time 'scenario 2 - screenupdating disabled Application.
For more information, see Server-to-server authentication and user profiles in Share Point Server 2013.