Password bypass in VBA

[Miya]

Hello gurus,

I have a spreadsheet with macros embedded in it. The spreadsheet has 4 visible tabs with references made to other tabs that are hidden with VBA. I hit Alt+F11 to see if I can view all the sheets contained in the workbook (generally I can see them all). In the VBAProject window, I see a menu item labeled "VBAProject(<filename>.xlsm)". When I try to expand the item, I am prompted for a password.

Is there a way to bypass or crack the password so I can retrieve the other hidden worksheets as well? I have not used it in a long time and forgot the password. There are a total of 13 sheets (if I remember right) that I need to retrieve.

I tried to winzip it and edit the vbaProject.bin file. The procedure instructs to open the .bin file in a HexEditor and replace DPB with DPx. However, I could not find those characters. It seems like the file is encrypted since there are all kinds of weird characters instead of letters.

I could upload the file but I am afraid company policy doesn't let me allow. Afterall, I am responsible to remember the password. Any help in this matter is highly appreciated.


Regards,
Miya.

 

[Hui]

Miya

Firstly, Welcome to the Chandoo.org Forums

I have never heard of the DPB method?

I use a technique where you access the XML directly in the Excel file
It is described here
http://datapigtechnologies.com/blog/index.php/hack-into-a-protected-excel-2007-sheet/

 

[Deepak]

Have you checked it!

http://chandoo.org/forum/threads/remove-password.23208/

 

[Debaser]

FYI, you don't need to access the VBProject to unhide sheets. You can use some code in another workbook to unhide them.