Unprotecting a Worksheet
 

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

Unprotecting a Worksheet
 

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



"Anney" wrote:

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

Unprotecting a Worksheet
 

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 ToolsMacroMacros 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" wrote in message
...
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

Unprotecting a Worksheet
 

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" wrote:

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 ToolsMacroMacros 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" wrote in message
...
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

Unprotecting a Worksheet
 

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" wrote in message
...
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" wrote:

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 ToolsMacroMacros 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" wrote in message
...
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

Unprotecting a Worksheet
 

Martin,

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

What i do now ... i am gona fadeup :(

Anney

"MartinW" wrote:

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" wrote in message
...
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" wrote:

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 ToolsMacroMacros 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" wrote in message
...
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

Unprotecting a Worksheet
 

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
ToolsProtectionUnprotect Sheet/Unprotect Workbook
Apart from that I have no other ideas.

Regards
Martin

"Anney" wrote in message
...
Martin,

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

What i do now ... i am gona fadeup :(

Anney

"MartinW" wrote:

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" wrote in message
...
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" wrote:

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 ToolsMacroMacros 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" wrote in message
...
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

Unprotecting a Worksheet
 

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

"Anney" wrote:

Martin,

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

What i do now ... i am gona fadeup :(

Anney

"MartinW" wrote:

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" wrote in message
...
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" wrote:

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 ToolsMacroMacros 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" wrote in message
...
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