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

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

Regards,
Peter T

"michael.beckinsale" <(E-Mail Removed)> wrote in message
news:dfa35a95-dc38-4d8e-bd65-(E-Mail Removed)...
> 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
>
>