Unprotecting a Worksheet

[Anney]

Guys..

I am working on a excell file which have total of 5 sheets.

for my working 2 of them are fix, now i want to delete other 3 sheets but
the sheet deletion option is greyed and i m unable to dele this sheet.

Secondly i have a Passsword breaker VB code script.... but i can't implement
it because the Module area also greyed ...

Plz help me out how can i unprotect and delete these sheets

Its urgent...

Regards,

Anney

 

[driller]

Anney

just for starting suggestion,

if you cannot delete the 3 sheets, and retain the two sheets, while the book
has a password,

maybe u can open a fresh BOOK1 and drag-in the 2 sheets at a time (while
holding Ctrl)......close the oldbook..save the new one... and use same old
bookname as it is - when other books are linked/referred from any of the 2
sheets...

goodluck

--
regards,
driller

*****
- dive with Jonathan Seagull

 

[MartinW]

Hi Anney,

Go to this site,
http://mcgimpsey.com/excel/removepwords.html

Don't copy the code, just download the workbook, then open
your locked workbook and this one at the same time. And
go to Tools>Macro>Macros and run allinternalpasswords.xls

This workbook stays hidden but don't worry it is there.
You will have to enable macros when you open it.

HTH
Martin

 

[Anney]

Martin!

Thx for this solution.

I had did same as you write, when i run macro, its saying..

there were no passwords on this sheet??

Anney

 

[MartinW]

Maybe you need to try this,
http://mcgimpsey.com/excel/fileandvbapwords.html

I've never tried it but it sounds like the decryptum service
maybe what you need.

If you do try it please post back and let us know
how you went, good or bad.

HTH
Martin

 

[Anney]

Martin,

Onceagain thanks dude ... but unfortunately ... its also not unprotecting my
worksheet or workbook??

What i do now ... i am gona fadeup

Anney

 

[MartinW]

I'm out of ideas. It certainly doesn't make sense.
If there are no passwords and no vba protection
then it should just be a matter of going to
Tools>Protection>Unprotect Sheet/Unprotect Workbook
Apart from that I have no other ideas.

Regards
Martin

 

[Mike H]

Anney,

If the file isn't confidential post it somewhere like below and post the
link and people can have a try:--

http://www.savefile.com/


Mike