excel courses in london - creating macro print some

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

resolvedResolved · Low Priority · Version Standard

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?

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


 

Excel tip:

Jumping Across the Excel Screen

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Alt+PgDn and Alt+PgUp is the equivalent across the spreadsheet.

View all Excel hints and tips


Server loaded in 0.08 secs.