Printing one page grayscale and one page color with code

I have a report that I use and right now I have a command button that prints the report x2. What I would like to do is to have it print one in color and one in grayscale. I could do this I think with two different buttons, but I would like to utilize just one. I tried creating a macro but it did not pick up the fact that I changed the properties to black and white. Any suggestions?

Thanks in advance

Hello 2funny4words,

Change the Worksheet name to match what your are using. his will print the first copy in blank and white, and the second copy in color.

Please Login or Register  to view this content.