Hi Greg

I actually came across your website and tried the 3 options but for some reason my content controls still seem to be printing

Starting to feel a bit hopeless vba is really not my strongest, I normally just used active X controls as I know they do not print. Had to use content controls this time as i am populating a drop down from sharepoint