vba to remove background cell colour when saved as pdf

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

thanks jacobshavn but that did not seem to work, only brought up an error

This is what i tried

sample forum 3.gif

is that correct?

i found that i forgot to put activesheet. in front of the range and it worked once i did that thanks. i only need this for the one sheet (calibration form) so the last post isn't necessary but thanks anyway. only trouble i have with it now is that it removes the colours cells not just from the pdf but also the worksheet too which i was hoping it wouldnt. i can live with it but if you know a way around this it would be good. also is it possible to remove the coloured cell that have been conditionally formated? im left with a few random greens and reds around the sheet

Thanks