Print in grayscale from macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pano - 03 Jul 2007 12:15 GMT

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??

Reply to this Message

shah shailesh - 15 Jul 2007 09:36 GMT

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.

> 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??

Reply to this Message