Creating a macro that converts spreadsheets to a pdf

Hello again everyone!

So I am starting to get ambitious with Excel now and am looking at creating a macro that will automatically create a pdf file of several worksheets at the same time. However this is my problem. Using the current version of Excel there is a wonderful record macro button, however when I try to include a function that would create a PDF, it says that I need to save any changes before creating the PDF. However when I save the file, I have to stop recording which defeats the whole purpose of creating the macro in the first place.

Please help and advise?

How can I use the record macro function to create my pdf macro without learning visual basic? If I cannot, can anyone give me some pointers as to how to write what it is that I am trying to accomplish?

Thank you in advance!