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

's Computer Specifications

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

's Computer Specifications

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

--
isabelle

Le 2011-05-21 04:16, Anders M a écrit :
> 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

's Computer Specifications

Superb!

Thank you

Den 21-05-2011 16:21, isabelle skrev:
> 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
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
creating a macro to print PDF	law8787	Microsoft Excel Programming	5	23rd Mar 2008 05:03 AM
Creating Print Macro	=?Utf-8?B?Q29uZnVzZWQ=?=	Microsoft Excel Misc	1	30th Apr 2007 12:53 PM
Creating a "print current page" macro or button	=?Utf-8?B?RGF2aWQgQi4gQXBwbGV0b24=?=	Microsoft Word Document Management	4	17th Feb 2007 07:25 AM
need help creating macro to auto print	=?Utf-8?B?VmF1Z2hu?=	Microsoft Word Document Management	1	17th Feb 2005 06:28 PM
Need macro to print each page as a different print job.	Karen Schneider	Microsoft Access Macros	2	27th Aug 2004 05:14 AM