Hi ppl,

Wondering if anyone can help me solve a way my macro can remove the interior background colours from all cells so it is just a white background with black borders and font when i save my workbook as a PDF via a saveas command button i already have set up. Only trying to do this because of some printing issues my office has because the sheets are printed in b&w.

The macro i use is

VBA pdf save as cal form 1-1.gif

I have found online some info along the lines of Range("Z1").Interior.ColorIndex = xlNone that i think will help but have no idea where to implement it into the macro. it may or may not, im not real sure. I need to be able to keep the borders around cells also

Sheet looks like this

Sample forum 1.png

And want it to look like this when saved as a PDF

Sample forum 2.png

I'm new to vba side of things so any help would be appreciated