My Excel Sheet having a password I forgot tht is there any way to open tht password protected sheet through VBA.As I want to see the formulas in tht...

look  at vba key in the internet (Google)

[Edited by humberto on 24-01-2005 at 12:57 AM GMT]

I dint get any vba key can u plz help me out i m sending tht excel sheet to u plz tell me the password for it..

____________________________
Attached:
TaxCalc_2005.zip 99 KB (Downloads: 14)

http://www.lostpassword.com/excel.htm
or go to here

http://www.discountpasswordrecovery.com/fileprotectedexcel.php

[Edited by humberto on 24-01-2005 at 01:50 PM GMT]

Hoop this help

____________________________
Attached:
TaxCalc_2005.zip 99 KB (Downloads: 15)

Check the attached macro.

just double click to install then the unlock worksheet option will come in tool menu. it only remove the password from sheets.

Hope it helps.

[Edited by nitinmukesh123 on 18-02-2005 at 08:42 AM GMT]

____________________________
Attached:
password.zip 10 KB (Downloads: 97)

Hi. Your small program works well . But I need the password that the sheet-creator used. Becouse I would like to relock the sheet

-- my problem that my office language different, then the protected excel standard, and I cant put correct date. dd.mm.yyyy instead yyyy.mm.dd (hungary). The cell is protected. With your program I able to unlock it, but I lost the original password. can I restore it?

Tnx!

ipocs try this one

[Edited by humberto on 13-03-2005 at 02:58 PM GMT]

____________________________
Attached:
Recoveringpassword.zip 10 KB (Downloads: 96)

I think this works :-)