save setting for print entire workbook

[Brian]

every time I choose print entire workbook and then hit ok
the next time I go to print, the button moves back to
print active sheet.

how can I keep it on entire workbook

thanks,
brian

 

[Vasant Nanavati]

Hi Brian:

AFAIK, It can't be done unless you want to write a crude and not completely
reliable macro using SendKeys, or create your own Print dialog.

Regards,

Vasant.

 

[brian]

Thank you

-----Original Message-----
Hi Brian:

AFAIK, It can't be done unless you want to write a crude and not completely
reliable macro using SendKeys, or create your own Print dialog.

Regards,

Vasant.




.