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

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
 
I

isabelle

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top