I am trying to program the worksheet in such a way that when it is opened regardless of whether it is opened by another person it shouldnt show the display alert instead it should open the worksheet and run the code.
But now after running the first 2 lines, when i check status in the immediate window it still shows displayalert and screenupdating status as true. why is it so? Anyone can enlighten me??? 

 
Sub Auto_Open()
 Application.DisplayAlerts = False
 Application.ScreenUpdating = False
.... 
....
 Application.DisplayAlerts = True
 Application.ScreenUpdating = True
End Sub