That has now stopped me from having to add a file location into the code however, it automatically saves to my desktop and then opens the 'SaveAs' option but there is no PDF option and it only lets me select 'All Files (*.*)'

My problem is that this document is for multiple people to use so they need to get the option of where to save the PDF file once they click the macro button.

Any further suggestions welcome and appreciated