PrintWorkbook function

[Bonnie]

Does anyone know how the printworkbook function works?

Thanks

 

[Ron de Bruin]

Do you mean this with vba code

ThisWorkbook.PrintOut
'the whole workbook where the code is in

ActiveWorkbook.PrintOut
'the whole active workbook

Worksheets.PrintOut
'all worksheets

Sheets.PrintOut
'all sheets

 

[Bonnie]

In the functions list is a PrintWorkbook function. There
are no instructions on how to use it. We really want to
avoid macros as the users will have to enable macros and
many are unsure about doing that.

-----Original Message-----
Do you mean this with vba code

ThisWorkbook.PrintOut
'the whole workbook where the code is in

ActiveWorkbook.PrintOut
'the whole active workbook

Worksheets.PrintOut
'all worksheets

Sheets.PrintOut
'all sheets


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




"Bonnie" <[email protected]> wrote in

message news:[email protected]...

 

[Dave Peterson]

I think you're already using macros.

I think PrintWorkbook is a function in one of the workbooks you've loaded.

Try starting excel in Safe mode.

windows start button|Run
Excel /safe

This avoids opening any other file.

Is the PrintWorkbook still listed?

===
there is a "Entire Workbook" option under the File|print dialog.