This example keeps the worksheet in Page Break Preview while setting the Normal view zoom
Pastabos
Values from 10 through 400 are accepted. When the worksheet is in Page Break Preview, this property stores the cached Normal view zoom that Excel restores when the user switches back to Normal view. When the worksheet is already in Normal view, this property matches the active view zoom This example keeps the worksheet in Page Break Preview while setting the Normal view zoom
Workbook.Sheets[
].View := xlPageBreakPreview; Workbook.Sheets[
].PageBreakPreviewZoom :=
Workbook.Sheets[1].View := xlPageBreakPreview;
Workbook.Sheets[1].PageBreakPreviewZoom := 80;
Workbook.Sheets[1].NormalViewZoom := 130;