ExcelBanter - macro to print workbook

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - macro to print workbook (https://www.excelbanter.com/excel-programming/383922-macro-print-workbook.html)

Phil

macro to print workbook

Can anyone help me with a macro to print a whole workbook?

Tom Ogilvy

macro to print workbook

ActiveWorkbook.Printout

--
Regards,
Tom Ogilvy

"Phil" wrote in message
...
Can anyone help me with a macro to print a whole workbook?

Phil

macro to print workbook

I'm sorry Tom Im new to macros I don't know what you mean by
"activeworkbook.printout

"Tom Ogilvy" wrote in message
...
ActiveWorkbook.Printout

--
Regards,
Tom Ogilvy

"Phil" wrote in message
...
Can anyone help me with a macro to print a whole workbook?

Rich[_2_]

macro to print workbook

Sub workbook()
activeworkbook.printout
End sub

"Phil" wrote:

I'm sorry Tom Im new to macros I don't know what you mean by
"activeworkbook.printout

"Tom Ogilvy" wrote in message
...
ActiveWorkbook.Printout

--
Regards,
Tom Ogilvy

"Phil" wrote in message
...
Can anyone help me with a macro to print a whole workbook?

Phil

macro to print workbook

I figured it out and it works great Thanks

"Phil" wrote in message
...
I'm sorry Tom Im new to macros I don't know what you mean by
"activeworkbook.printout

"Tom Ogilvy" wrote in message
...
ActiveWorkbook.Printout

--
Regards,
Tom Ogilvy

"Phil" wrote in message
...
Can anyone help me with a macro to print a whole workbook?

All times are GMT +1. The time now is 01:52 AM.