Excel sheet gives screen flicker/refresh constantly

It is for Excel programming like Macro, function, formula, Pivot and other platform support..
alpeshviranik
Posts: 81
Joined: Thu Jul 17, 2014 4:58 pm
Contact:

Excel sheet gives screen flicker/refresh constantly

Postby alpeshviranik » Wed Jul 30, 2014 5:33 pm

Excel sheet gives screen flicker/refresh for some time when i am calling function or at the time of worksheet activate. What causing the flicker in excel VBA?


Guest

Re: Excel sheet gives screen flicker/refresh constantly

Postby Guest » Wed Jul 30, 2014 5:38 pm

I think screenupdating is true and it will cause the poblem of flickering in Excel VBA code.
So do Application.Screenupdating = False in the starting of your Macro and Application.Screenupdating = true in end of macro. You can also use Application.EnableEvents = False, if you have more then one worksheet and other application calling during macro call.

You can apply below code in you function.

Code: Select all

Public Sub Worksheet_Activate()
'stating of sub
Application.Screenupdating = False
Application.EnableEvents = False
Call macroA
Call macroB
'end of sub
Application.EnableEvents = True
Application.Screenupdating = True
End sub


Return to “Microsoft Excel and VBA Forum”

Who is online

Users browsing this forum: No registered users and 0 guests