Screenupdating not working

Posted by / 14-Sep-2017 10:21

' -------------------------------------------------------------------------------- ' Copyright 1999-2015, Shyam Pillai, All Rights Reserved.

' -------------------------------------------------------------------------------- ' You are free to use this code within your own applications, add-ins, ' documents etc but you are expressly forbidden from selling or ' otherwise distributing this source code without prior consent.

is your source for cost-effective Microsoft Excel training.Raise Number:=vb Object Error ERR_NO_WINDOW_HANDLE, _ Description:="Unable to get the Power Point Window handle" Exit Property End If If Lock Window Update(hwnd) = 0 Then Err.Raise Number:=vb Object Error ERR_WINDOW_LOCK_FAIL, _ Description:="Unable to set a Power Point window lock" Exit Property End If Else ' Unlock the Window to refresh Lock Window Update (0&) Update Window (hwnd) hwnd = 0 End If End Property 'Sample Usage: Sub Long Processing Sub() ' Lock screen redraw Screen Updating=False ' --- Long time consuming code ' Redraw screen again Screen Updating=True ' Also see below article for another example of usage of the code End Sub It's fairly simple to open a Power Point file (*.ppt) for editing using VBA code however opening a Power Point Show (*.pps) file for editing is altogether another matter. Open method and it defaults to open the file in Slide Show mode. The routine below illustrates a manner of woring around the default behaviour and opening the file for editing.Many people write their own macros to manipulate the information in a workbook.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.

screenupdating not working-72screenupdating not working-89screenupdating not working-34

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

One thought on “screenupdating not working”

  1. Mae llawer un yn ei gofio fel gwr bonheddig a thawel ei natur wel, mi fedra i dystio mai nid felly oedd hi pob tro yn yr ystafell newid pan doedd ei dm ddim yn chwaraen dda!!