Change view without activating sheet? - Repost

[michael.beckinsale]

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

 

[Peter T]

Why the repost, looks same as your first post just a couple of hours
earlier.

Regards,
Peter T