Need Guidance and Alteration on My Own Workbook - Creating PDF and Mail

Hi All
I found 1 website with great code and guidance. Just that, it is too complicated and i do not know what i should i do 1st to my own workbook.
After downloading the sample workbook, i found that, there is "functionsModule"'s Modules and the code that i wanted to use is "CreatePDFMail".

I had attached my workbook name "Screening.xlsm" and Sample of workbook from MSDS name "PDF-Example".

What should i do on my workbook "Screening.xlsm"? Do i need to write down things like the sample workbook on, "Microsoft Excel Objects"> Info(Info)? Before proceeding with VBA Code?

I wish to create pdf on selected sheet, example sheet name "hbl". Only.

And attach it to outlook. User manually key in email address.

Hi Jaslake
It works nicely for me. But how to add on a little technical code, like
On HBL sheet, i had made 2 printable pages. Possible to create PDF is filled range only? Example like page 2's cell A72 is filled then creating PDF on 2 pages of sheet(HBL)

Hi Jaslake
Sorry for my bad explaination.
On my sheet "HBL" i made the form which printable in 2 pages.
I wish to create pdf on page 2 where cell "A72" is filled only. Instead of entire sheet (5)/HBL.

Is this possible?

Hi Jaslake
Wonderful! Just like what i want! Very appreciate for your quote and thank you so much.

Regards
Cychua