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