Creating a print-macro that'll only print page 1?

  • Thread starter Thread starter Anders M
  • Start date Start date
A

Anders M

Hi,

I have a spreadsheet that contains multiple sheets. I want to add a
button that runs a macro, which only prints page 1 on the first sheet
(called Scorekort).

The "Scorekort" sheet contains 13 pages in total, but I only want to
print the first page.

Any ideas for this macro?

Anders
 
hi,

Sub Macro1()
Sheets("Scorekort").PrintOut From:=1, To:=1, Copies:=1, Preview:=True, Collate:=True
End Sub

if you don't want a print preview, Preview:=False
 
Back
Top