PDA

View Full Version : Encrypt a worksheet in a workbook using VBA



rjudge
04-10-2013, 06:33 PM
Well, live and learn. I have a worksheet that is password protected and "very hidden" using VBA. Seemed to do the job. Then I used Access to import several of the other worksheets from the same workbook and the Hidden worksheet not only showed up but is completely viewable and importable into Access. That is not good for me. I need to encrypt it in such a way that someone cannot use Access to view it.

I have looked and looked to no avail, but I know someone here has a very simple sample of code to encrypt a single worksheet in a workbook. Your guidance will be greatly appreciated.