Fax Software

Community Forums

#5847

admin
Keymaster

This is possible but you will have to modify the Excel code in the original macro to print the selection instead of the entire workbook.

The code in the macro uses “ActiveWorkbook.PrintOut”
which prints the entire workbook.

so, you would have to change this line to whatever you want to do.
Examples:

ActiveWorkbook.PrintOut
‘the whole workbook

Worksheets.PrintOut
‘all worksheets

Sheets.PrintOut
‘all sheets

Sheets(Array(“Sheet1”, “Sheet3”)).PrintOut
‘all sheets in the array

ActiveWindow.SelectedSheets.PrintOut
‘print all selected sheets

ActiveSheet.PrintOut
‘only the activesheet

Sheets(“Sheet1”).PrintOut
‘only “Sheet1”

Selection.PrintOut
‘print only the selection

Range(“C1:D5”).PrintOut
‘print range