Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses in london - Creating a Macro to print some but not all sheets of a workbook

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

ResolvedVersion Standard

Wed 15 Aug 2007, 09:50 Delegate Peter said...

Peter has attended:
Excel Advanced course

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

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

Wed 15 Aug 2007, 10:01 Trainer Richard said...

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

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

Training courses

98.6 % recommend us

More live stats...

Training information:

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips