Save in PDF a excel sheet

Dear all,

I am a brand new user on the forum, thus HELLO everyone !

I encountered an issue to create a macro allowing to save a excel sheet 2007 in PDF format.

Particularity of my sheet "Site PROFILE :
In the cell B5 of "Site PROFILE" I have to type a code which allow to consult the results of each code ("sheet1").
To sum up I have only one sheet "Site PROFILE" for several results.

Request
I tried to create a macro which type every code containing in the "sheet1" and save each code in my DOCUMENTS folder for instance, but Its not working at all...So, someone could kindly help me?

Many thanks for your help and advice in order to help me to build my Macro "Module 8" in the file attached.

Kind regards,

Hello,

Thank you for you reply Blue, but unfortunatly I dont know how to use your macro...When I incorporate your code witihn my Macro Its not working at all. I suppose I missed something important.

If you could help me with it will be great !

Many thanks,

Blue,

When I click on the shape "Save pdf whole sheet" I can see that creates a spreadsheet "chart1" with the code 7508 only, but after that I have the message error 5 "Invalid procedure call or argument".

Thanks

You created the macro on the module 4 ? I

First of all, thanks you so much for the time spend to help me.

Secondly, I saw when I change the code, the macro creates a chart1 sheet as a picture format but not saved in my desktop and with the message error 5...

My request was, could we automticly save all the code including in the sheet 1 in PDF in the desktop for instance? Because with your Macro we have to type each code no?

Many thanks,

OK thanks for your quick reply.
I'll conitnue to investigate how could I get all my codes saved in pdf format.
I'll post my resolution if I'll succeed,

Bye,