shu qi and leon lai dating - Vb application screenupdating


New Window ' Unlock the window to start refreshing again Screen Updating = True Exit Sub Err Handle: If Err.Can anyone tell me the VB to stop my Excel Macro from updating the screen while it runs.

vb application screenupdating-58vb application screenupdating-53

' --------------------------------------------------------------------------------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.

In other words - when I click run - I just want a message saying "Macro Running" or something - then the code will run and finish and the finished position will be displayed with a message like "Macro Finished".

I don't want users to see the screen 'flicking' around as the code moves between cells and worksheets Any help gratefully recieved Dan Dan Auber Dan [email protected], The code to stop the screen updating is Application. Msg Box "Macro complete", vb OKOnly vb Information, "Title"Application.

Screen Updating = False Try it in combination with these lines: Application. Screen Updating = True Just some additional info: If you want to do this in VBA for Access, the command is: Do Cmd.