Thanks Paul
I tried a macro and put the code in a commandbutton,would not fire up. In my top code the SaveAs box defaults to cell C16 for the name, was not sure if
this could be done when opening the pdf dialog. Now when you open the pdf dialog it defaults to active sheet, was hoping to have it default to a value in C16. I
will update my profile to 2007
z