Canadafreexxx com - Screen updating hidden in vba

Many times the macro may do quite a bit with the data, such as selecting different cells, replacing values or formulas, and taking other types of actions.

screen updating hidden in vba-54

Screen Updating to its previuos value, not necessarily to True.

this to mantain possible settings to False coming from calling subs Am I missing something?

The idea is to use the first line near the beginning of your macro, and then use the second line near the end.

Thus, the main body of your macro can do its work behind the scenes without the necessity of stopping to update the screen.

but with no idea of why should that happen with excel 2013-W8 only.

besides, both machines are laptops and the excel2013-W8 being more powerful, so that should not be a matter of opening file speed, should Application. and just to finish checking all of your suggestions/doubts @westconn1: I actually put calls to my Screen Updatejust(False, previous Screen Update) at the beginning of every procedure to make sure I had 'Application.

Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next Sub put Numbers In Cells() Dim ws As Worksheet Dim j As Long Dim resp As Integer Set ws = Active Sheet resp = Msg Box("Turn off updating? Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next dim previous Screen Update as boolean Call my Screen Update(False, previous Screen Update) 'to get the current setting into previous Screen Update Call my Screen Update(True, false) 'to set updating to false 'do your heavy code here and when finished: Call my Screen Update(True, previous Screen Update)maybe you have fiddled around with the code and thought the first "Call my Screen Update(True, previous Screen Update)" is useless/wrong?

Screen Updating = True Msg Box "done" End Sub Sub put Numbers In Cells() Dim ws As Worksheet Dim j As Long Dim resp As Integer Set ws = Active Sheet resp = Msg Box("Turn off updating? Screen Updating = previous Screen Update Else previous Screen Update = Application. Screen Updating = False End If End Sub And there I found that the first call (and the second too, I guess) was uneffective Can it be it's because of some maliciuos interaction between Application. But always remind that I get no flickering in Excel 2010.

There are no other macros in the book and the sheet is not protected.

Comments are closed.