VBA for excel, printing

[versanctus1]

is it possible to set the printing option to whole workbook as the default when a workbook is opened, I have tried various options but can't quite get it.
any help would be much appreciated.

 

[PHV]

Use the Workbook.PrintOut method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[versanctus1]

I tried using that and thta automatically prints the workbook I want to set the workbook as the default when the book opens so as when the user prints the document it automatically prints the whole workbook

 

[SkipVought]

versanctus1,

Please read your last post carefully and post again.

Skip,

_[red][/red]

 

[versanctus1]

What I would like to do is when the user selects print then the workbook value is the default (as oposed to current sheet), as soon as I run the workbook.print macro it automatically prints the workbook, I don't know if I am explaining this clearly but it has been bugging me. I do appreciate any and ll help