I am using Excel 2007, and it already has the ability to Save As PDF.
However, I would like to add a button to the sheet that allows me to
click it and then a dialog box pops up to let me browse to where I
want to save the file and what I want to name it, and only allowing it
to be Saved as a PDF.

I have found some information, but most of what I have found involves
using other data on the sheet to pre-deternine the name and/or
location of the file.

Any help would be appreciated.

thanks!

magmike