B
Bonnie
Does anyone know how the printworkbook function works?
Thanks
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
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
ThisWorkbook.PrintOut
'the whole workbook where the code is in
ActiveWorkbook.PrintOut
'the whole active workbook
Worksheets.PrintOut
'all worksheets
Sheets.PrintOut
'all sheets
B
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.
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.
message news:[email protected]...-----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
D
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.
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.