Change view without activating sheet? - Repost

  • Thread starter Thread starter michael.beckinsale
  • Start date Start date
M

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
 
Why the repost, looks same as your first post just a couple of hours
earlier.

Regards,
Peter T
 
Back
Top