| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unprotecting a Protect Worksheet | Excel Worksheet Functions | |||
| Unprotecting the unprotected | Excel Discussion (Misc queries) | |||
| Unprotecting worksheets | Excel Worksheet Functions | |||
| unprotecting a worksheet | Excel Discussion (Misc queries) | |||
| Unprotecting Cells in a Protected Worksheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
