Page Setup to select that option?
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sunny Kapoor
Sent: Monday, May 14, 2012 12:55 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in
ecel
Hm
elect that option?
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Sunny Kapoor
> *Sent:* Monday, May 14, 2012 12:55 PM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$E
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in
ecel
Hmm,
Well, do you think of something thats avoiding the macro from printing in
colour??
Sunny
On Mon, May 14, 2012 at 9:53 PM, dguillett1 wrote:
My ans was based on wha
>
> *From:* Sunny Kapoor
> *Sent:* Monday, May 14, 2012 2:38 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA
> in ecel
>
> well, Thanks for your reply.
>
> However, the file is quite big with more than
My ans was based on what you sent
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Sunny Kapoor
Sent: Monday, May 14, 2012 2:38 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel
well, Thanks for
well, Thanks for your reply.
However, the file is quite big with more than 25 sheets. I sent one sheet
to give an example.
Now, the file will be used by many people but everyone would be interested
in different sheets. The problem i am facing currently, like you must have
seen is, the macro print
Based on the file you sent me with ONE sheet with graphs the easiest way would
be to set up an additional printer with ONLY grayscale and call it bw or
whatever and then print to that printer for bw and the other for color.
Application.Dialogs(xlDialogPrinterSetup).ShowDon Guillett
Microsoft MVP
Send me your file and tell me your excel version. I’ll look a bit later.
When you say give the user an option to print. What do you mean. Be VERY
specific.
What I did will should do it for each sheet in the file when it is printed.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gma
