excel courses in london - Creating a Macro to print some but not all sheets of a workbook

The UK's most regular instructor-led training courses.
Training information: excel courses in london · Excel/courses/london · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Creating a Macro to print some but not all sheets of a workbook

Peter has attended:
Excel Advanced course

by - delegate Peter [1 post] (2007 Aug 15 Wed, 09:50) Reply

How do you create a macro to print some but not all sheets of a work book?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	4	book now	£207	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Creating a Macro to print some but not all sheets of a workb

by - trainer Richard platinum contributer [813 posts] (2007 Aug 15 Wed, 10:01) Reply

Start recording the Macro.

To print only specific sheets, simply click on the sheets, holding the CTRL key.

Then FILE > PRINT.

Be sure to deselect the sheets once you have printed, by clicking on any non-selected sheet.

Stop Recording the Macro.

Regards

Richard

· How to Create Better Excel Spreadsheets: Part One
· Advanced level training: Microsoft Excel and the Web
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips

Excel tip:

Use the Format Painter to copy formatting more than once in Excel

The format painter tool provides a quick and easy way to copy formatting from one cell to another in Word.

The only problem is that if you click the Format Painter once to turn it on, you can only click and drag over a single cell or adjacent range of cells; then the Format Painter turns itself off automatically.

If you want to copy formatting to cells or groups of cells that are not adjacent to each other, double-click the Format Painter - this way you will be able to copy formatting to multiple cells.

When you have finished using Format Painter, press the Esc key or click on the Format Painter button once to turn it off.

View all Excel hints and tips