VBA Password
-
- 5StarLounger
- Posts: 1177
- Joined: 22 Jul 2013, 18:29
VBA Password
I locked my excel VBA document with a password and cant remember what it is.. for some reason I wrote it down and i must have written the wrong password.. is it possible to unlock?
-
- Administrator
- Posts: 78412
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: VBA Password
Is your workbook a .xls file or a .xlsm/.xlsb file? Excel uses much stronger encryption for the latter.
Best wishes,
Hans
Hans
-
- Administrator
- Posts: 78412
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: VBA Password
Thanks. Try the procedure described in Unlock a VBA password protected Excel file, Use a copy of the workbook, not the original, so that if you damage the file during the procedure, you'll still have the original.
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 1177
- Joined: 22 Jul 2013, 18:29
Re: VBA Password
worked great thank you