Hi Everyone,

is it possible to set the "Print entire Workbook" property from code ? I
haven't found a way so far.

Can anyone help me on this ?

thanks,
Oliver

if fileprintyou would have found it.

ActiveWorkbook.PrintOut Copies:=1, Preview:=True, Collate:=True

--
Don Guillett
SalesAid Software

"Oliver" wrote in message
...
Hi Everyone,

is it possible to set the "Print entire Workbook" property from code ? I
haven't found a way so far.

Can anyone help me on this ?

thanks,
Oliver

Hi,

thanks for your quick reply. using your snippet prints the workbook
directly. What i want to do is only set the property that it is marked by
default when the user opens the print dialog.

Any advice on this ?

thanks

"Don Guillett" wrote:

if fileprintyou would have found it.

ActiveWorkbook.PrintOut Copies:=1, Preview:=True, Collate:=True

--
Don Guillett
SalesAid Software

"Oliver" wrote in message
...
Hi Everyone,

is it possible to set the "Print entire Workbook" property from code ? I
haven't found a way so far.

Can anyone help me on this ?

thanks,
Oliver

There is no built in setting that I am aware of that controls this.

--
Regards,
Tom Ogilvy

"Oliver" wrote:

Hi,

thanks for your quick reply. using your snippet prints the workbook
directly. What i want to do is only set the property that it is marked by
default when the user opens the print dialog.

Any advice on this ?

thanks

"Don Guillett" wrote:

if fileprintyou would have found it.

ActiveWorkbook.PrintOut Copies:=1, Preview:=True, Collate:=True

--
Don Guillett
SalesAid Software

"Oliver" wrote in message
...
Hi Everyone,

is it possible to set the "Print entire Workbook" property from code ? I
haven't found a way so far.

Can anyone help me on this ?

thanks,
Oliver

Oliver,
According to VBA help on "Built-In Dialog Box Argument Lists":
"xlDialogPrint
range_num, from, to, copies, draft, preview, print_what, color, feed,
quality, y_resolution, selection, printer_text, print_to_file, collate"

I would guess "print_what" is what you need, but I have no idea what value
is expected.
Some experimentation is required.

NickHK

"Oliver" wrote in message
...
Hi Everyone,

is it possible to set the "Print entire Workbook" property from code ? I
haven't found a way so far.

Can anyone help me on this ?

thanks,
Oliver