Thank you for the reply.

I do not want to print out the workbook. I actually want to change the
default setting of Excel Printing (the settings in the Print Dialog
box). In this case, I want to change the "Print What" value from
"Active worksheet" to "Entire workbook", therefore, my Excel
application can always print whole workbook instead of just the active
worksheet.

Regards,
Gorton



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