Free senior flirt chat rooms - Application screenupdating excel

New Window ' Unlock the window to start refreshing again Screen Updating = True Exit Sub Err Handle: If Err.

' --------------------------------------------------------------------------------Sub Open PPSFor Edit() On Error Go To Err Handle Dim p Show As Presentation ' Lock the window to prevent refreshing ' See above article example for the code Screen Updating = False 'Open the show, however use additional flag - With Window set to FALSE Set p Show = Presentations.

Open("C:\sample.pps", _ With Window:=mso False) 'Open a window now to the presentation for editing p Show.

Without a code sample it is very dificult to understand your problem (please see https://stackoverflow.com/help/how-to-ask and edit your question appropriately.

Here are some ideas: - Check if your code calls for code in a different procedure, maybe the Application.

By leaving the main window alone, and forcing other workbooks to become not visible, letting the code run, then bringing them back to visible, it stopped flickering.

I was able to solve the issue to my liking by using a workaround this 'which window is on top' problem.

Screen Updating property is useful when running macros that jump from cell to cell, sheet to sheet, and workbook to workbook. Screen Updating to False stops your screen from flickering (refreshing) as your macro runs.

I see people struggling with Excel every day and I want to help.

I’ve seen the threads on this subject that recommend “fiddling with the code” or “calling the code in a subroutine”.

Tags: , ,