View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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