My macro will not run b/c the sheet is protected

[sneel3]

how can I have the macro turn off the protection at the beginning and turn it back on at the end?

 

[tusharm]

The password is "FALSE" (alternatively, it is "TRUE"). In

Option Explicit

Sub testProtect()
    Dim Password As String
    ActiveSheet.Protect Password = "stu"
    End Sub

or

Sub testProtect()
    ActiveSheet.Protect Password = "stu"
    End Sub

VBA evaluates 'password="stu"' as a logical test that returns either TRUE or FALSE. Assuming the variable named password doesn't contain the string "stu", the code becomes ActiveSheet.Protect FALSE and VBA coerces the boolean into a string to get ActiveSheet.Protect "FALSE"

joe have you tested what im saying????

cause as a quote from you

ActiveSheet.Protect password = "stu"
is the same as:

ActiveSheet.Protect

it isnt the same at all
cause
ActiveSheet.Protect
wouldnt want a password to unprotect

but


ActiveSheet.Protect password = "stu"

does expect a password to unprotect

ande the password isnt "stu"

hey hey

Stu

 

[tusharm]

What's the current code? What line generates the problem? What's the error?

I still can't get it to work. Any other ideas???

 

[Joe Was]

Tushar,

This is new to me!
I tested it and this wrong syntax, does work with a passwoed of:

FALSE

and it will not take any other format of this, like:
False, false, -1, 0, 1

This is a good thing to know!

It never occured to me to try a Boolean. I like it, when I learn something new, thanks.

 

[tusharm]

Yeah, that's the problem with languages like VB (and others like C) which coerce data types willy-nilly.

Of course the problem is mitigated -- not eliminated, mind you -- if Option Explicit were set.

I am not sure I understand the problem with the other values.

ActiveSheet.Protect False

sets the password to FALSE (all upcase)

ActiveSheet.Protect -1

sets the PW to -1

Essentially, the key here is that the syntax is
.Protect {string}
and anything you provide that can even remotely be converted into a string will be -- at times with unexpected and maybe even potentially disastrous results.

Tushar,

This is new to me!
I tested it and this wrong syntax, does work with a passwoed of:

FALSE

and it will not take any other format of this, like:
False, false, -1, 0, 1

This is a good thing to know!

It never occured to me to try a Boolean. I like it, when I learn something new, thanks.