I have an excel file with several sheet. I only want to save the one with patient report in pdf and then encrypt it with unique password, say the patient ID. I am using acrobat DC extension right now. but i have to key in the name and password manual. I was wondering if this can be automated by means of vba where I dont have to key in the name and id myself.