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

” then ActiveSheet.PageSetup.BlackAndWhite =False ‘end if End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Sunny Kapoor Sent: Monday, May 14, 2012 9:56 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Printing sheets in colour using VBA in ecel Hi Guys,

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

Hi Guys, I am trting to print sheets in colour using VBA. I am using the following code... Sub Print_sheet() With ActiveSheet .PageSetup.BlackAndWhite = False .PrintOut Copies:=1, Collate:=True End With End Sub _