Hello all,
My problem is: Excel does not seem to execute my commands.
Nevertheless the values of the objects aren't updated. The values are: True and continue to be: True.
Application.ScreenUpdating = False Application.DisplayAlerts = False
I already made a new Excel file. Containing a macro with only the text above, but problem persists. It seems to be a setting; it has worked and it no longer works. Does anyone have an idea what's going on.
If you're stepping through the code, ScreenUpdating will remain True. I guess that's so that you can see what is happening on the worksheet.
Don't know about the DisplayAlerts. What message is it displaying that it shouldn't?
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Both of those settings reset to True when your code ends and also appear True in step through mode.
Everyone who confuses correlation and causation ends up dead.
@RS: thanks for the confirmation. I knew that ScreenUpdating remained True during Step Through (as it caused me some confusion at one point) but I hadn't realised that DisplayAlerts did the same. Good to know.
Love the signature. I think I've met some of those psychopaths
Yes, i am stepping (F8) through the code, so that is the reason why. In Word VBA updating does work, so is different in Excel. When I run the macro (F5) in excel everything works well indeed.
Thank you all for replying.
You're welcome.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Hiawatha 
Register To Reply
Bookmarks