Print in grayscale from macro

External Since: Jul 03, 2007 Posts: 1

Howdy, is it all possible to be able to make a sheet which is in color
print in grayscale from a macro without bringing up the printer dialog
box???

If that cant be done is there a way to bring up the printer options
from a macro so you can manually change to select grayscale??

External Since: May 27, 2007 Posts: 36

Try,

Application.Dialogs(xlDialogPageSetup).Show

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.

"pano" <tricav.RemoveThis@aanet.com.au> wrote in message
news:1183461338.171856.11780@o11g2000prd.googlegroups.com...
> Howdy, is it all possible to be able to make a sheet which is in color
> print in grayscale from a macro without bringing up the printer dialog
> box???
>
> If that cant be done is there a way to bring up the printer options
> from a macro so you can manually change to select grayscale??
>