Not to clear on what you are looking for, but if you are looking to print
the entire workbook then it is

Workbooks.Application.ActiveWorkbook.PrintOut

Thurman
"gortonz" wrote in message
...
I tried building a COM Add-in to change the Excel Printing Default
Setting from Active Sheet(s) to Entirebook. I also want to set the
default Print settings in Print Dialog programmatically when the Excel
starts up.

I would appreciate any helps on this.

Thanks,
Gorton



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/