Hello Don,
Thanks for the reply. Actually, i ned to give the user an option to print
the sheet if he/she wants. Also, the command ou provided does not work. The
print out is still not coloured.
let me know if you could suggest something else...
Sunny
On Monday, 14 May 2012 16:56:25 UTC+2, S
...@gmail.com
From: Sunny Kapoor
Sent: Monday, May 14, 2012 10:23 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel
Hello Don,
Thanks for the reply. Actually, i ned to give the user an option to print the
sheet if he/she wants. Also, the
Excel
SalesAid Software
dguille...@gmail.com
From: Sunny Kapoor
Sent: Monday, May 14, 2012 11:02 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel
Hi,
I have attached the file...Please let me know what should i do...
Thanks in
; dguille...@gmail.com
>
> *From:* Sunny Kapoor
> *Sent:* Monday, May 14, 2012 11:02 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Re: Printing sheets in colour using VBA in
> ecel
>
> Hi,
>
> I have attached the file...Please let me know wha
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
>
> *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
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
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
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