Can't unprotect the sheet

**stojko89** · 11-22-2011, 07:47 AM

Hi

I was using the wrong code for protecting a sheet:

Please Login or Register  to view this content.

Insted of

Please Login or Register  to view this content.

Now I can't unprotect the sheet with the password impro01 can anyone tell me what's the password or how can I find out?

**john55** · 11-22-2011, 07:52 AM

try this

Please Login or Register  to view this content.

**Domski** · 11-22-2011, 07:54 AM

It will have populated the password as the boolean result of the test.

You can therefore unprotect it using:

Please Login or Register  to view this content.

Dom

**stojko89** · 11-22-2011, 07:55 AM

LOL ! john55

Tnx man. I did it like this the first time but then I just didn't think of that

Fix my problem (lame problem - but it can happen I guess).

Thank you very much !

**Winon** · 11-22-2011, 08:09 AM

Domski,

Should it not be "Protect False" ?

**Domski** · 11-22-2011, 08:27 AM

Nope. The OP obviously doesn't use Option Explicit to enforce declaration of variables. In which case when protecting the worksheet it is evaluating Password = "impro01" with Password being a variable as False. Therefore to unprotect the sheet you can use False or the same test again as john55 pointed out.

Dom