Mark has attended:
Excel VBA Intro Intermediate course
Excel Advanced - For Power Users course
Excel PowerPivot course
Excel Dashboards for Business Intelligence course
Flickering Screen
Hi,
I have a document that has some VBA located in various sheets, however on one sheet within the document there isn't any yet when viewing the spreadsheet I get a constant flickering of the cells.
I've created a copy of the sheet and moved it to a new document and the flickering isn't present.
I have recorded a video of this if anyone can help?
Thanks,
Mark
RE: Flickering Screen
Hi Mark,
Thank you for the forum question.
Does it stop flickering if you turn Automatic Calculation to Manual?
If it something to do with the macro you can put the lines in the macro:
Application.ScreenUpdating=false
Application.Calculate = xlManual
the above lines must be at the top just after the Sub line
and just before the End Sub line type:
Application.ScreenUpdating=true
Application.Calculate = xlAutomatic
Please let me know if this didn't solve the issue.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
