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???
Please Login or Register to view this content.
Application.DisplayAlerts = False
It is an application setting which can be controlled from any of the excel workbook.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Application.DisplayAlerts = False
Above code is not working for me. For some reason even after i run this line displayalert property is still set to true.
[FONT=Arial]Enter this in immediate window after turning off the display alertsOriginally Posted by mekha
Please Login or Register to view this content.
When i run the code after 'Application.DisplayAlerts = False' is executed i checked the status in the immediate window and it shows TRUE.
then i tried to set 'Application.DisplayAlerts = False' status through immediate window and checked the status in immediate window. The status is changed to FALSE. Do not know why it doesnt work when i run the code...
It's working perfectly!
As I said earlier turning off the alerts is relates to application which can be turned on by running some other code.
So check whether any of the other codes which may turn it on while running
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks