You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Does anyone know of a good method for shading Excel cells so that they appear shaded with color on the screen, but will never be the type of shading which would print the color?
I want to shade some cells, but never want the color to print regardless of how the user goes about printing the document.
Great, that works. And, what I have also done now is format a background into the sheet via bitmap of just a solid color as apparently backgrounds never show up in print.
So, with your idea and mine I have enough to work with.