2 Replies Latest reply: Jun 8, 2013 12:36 AM by Test Screen Name RSS

    Visual Basic Password

    Lauren04 Community Member

      Hi,

       

      I need to know if there's a way I could save my excel document protected by a Password into a PDF file, I think I cannoot do it with just excel but is there a way that just using Macros I could use Adobe Acrobat to protect my PDF, I don't want to buy the product if It won't work

       

       

      Thank You

        • 1. Re: Visual Basic Password
          Bill@VT CommunityMVP

          You can use the security settings in the document properties. These can also be automated as part of the creation process with Acrobat. You might want to check out the trial and see if the process is sufficient for you -- PDFs are not always as secure as folks would like. An alternative is to create the PDF and then send it as a secure zip file.

          • 2. Re: Visual Basic Password
            Test Screen Name CommunityMVP

            I don't think there is a way to use VB to set different passwords for each file made. People wanting to develop with Acrobat will need to download and read the Acrobat SDK, it isn't viable to just try and pick it up, or use object inspectors, and there isn't a macro recorder.