VBA Password

JoeExcelHelp
5StarLounger
Posts: 1177
Joined: 22 Jul 2013, 18:29

VBA Password

Post by JoeExcelHelp »

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?

User avatar
HansV
Administrator
Posts: 78412
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: VBA Password

Post by HansV »

Is your workbook a .xls file or a .xlsm/.xlsb file? Excel uses much stronger encryption for the latter.
Best wishes,
Hans

JoeExcelHelp
5StarLounger
Posts: 1177
Joined: 22 Jul 2013, 18:29

Re: VBA Password

Post by JoeExcelHelp »

.xlsm

User avatar
HansV
Administrator
Posts: 78412
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: VBA Password

Post by HansV »

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

JoeExcelHelp
5StarLounger
Posts: 1177
Joined: 22 Jul 2013, 18:29

Re: VBA Password

Post by JoeExcelHelp »

worked great thank you