Hi All,

Below is a code snippet from a routine that loops through each sheet
in a workbook. The routine copies / pastes ranges into powerpoint so
l
need to ensure the sheet is in normal view to avoid pages numbers etc
being passed to PP


Sht1.Activate
If ActiveWindow.View = xlPageBreakPreview Then
ShtView = "Yes"
ActiveWindow.View = xlNormalView
End If


How can l achieve this without using Sht1.Activate?


I want to avoid the 'flashing' caused by the Sht1.Activate. If l use
Application.Screenupdating = False the data is not passed to PP


Regards


Michael