Create a macro that will create a PDF file and email

Hi

I would really like help to create a macro that will save the active sheet as = "cellA1" as a PDF, open up the save as box.

Many thanks in advance.

Matt

put this in a standard module and test:

Please Login or Register  to view this content.

That is great, thank you. How can I get to open up a save as box?

i think this is what you want, eh?

Please Login or Register  to view this content.

Thank you!