just record a macro saving the activesheet as pdf...but your charts won't be there!
I am sorry, I have no other idea!