$$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

2012-05-14 Thread Sunny Kapoor
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

Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

2012-05-14 Thread dguillett1
...@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

Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

2012-05-14 Thread dguillett1
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

Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

2012-05-14 Thread Sunny Kapoor
; 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

Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

2012-05-14 Thread dguillett1
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

Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

2012-05-14 Thread Sunny Kapoor
> > *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

RE: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

2012-05-14 Thread Asa Rossoff
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

Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

2012-05-14 Thread Sunny Kapoor
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

RE: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

2012-05-14 Thread Asa Rossoff
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