allow edit ranges protection
 

how can i delete the protection in allow edit ranges via subroutine in
vbscript editor? tks.

allow edit ranges protection
 

Record a macro while going through the steps and look at the generated code.

Tim


"eehj23" wrote in message ...
how can i delete the protection in allow edit ranges via subroutine in
vbscript editor? tks.

allow edit ranges protection
 

have already tried it but if i look at the generated code, it seems that it
uses an array but the index are not in order such as (1), (0), (1), (1)

"Tim Williams" wrote:

Record a macro while going through the steps and look at the generated code.

Tim


"eehj23" wrote in message ...
how can i delete the protection in allow edit ranges via subroutine in
vbscript editor? tks.

allow edit ranges protection
 

....and the code looks like ?

I'm asking partly because I'm not even sure what it is you want to do: posting [a small example] of what you record will help.

Tim


"eehj23" wrote in message ...
have already tried it but if i look at the generated code, it seems that it
uses an array but the index are not in order such as (1), (0), (1), (1)

"Tim Williams" wrote:

Record a macro while going through the steps and look at the generated code.

Tim


"eehj23" wrote in message ...
how can i delete the protection in allow edit ranges via subroutine in
vbscript editor? tks.

allow edit ranges protection
 

the code looks like this:

activesheet.protection.alloweditranges(1).delete
activesheet.protection.alloweditranges(3).delete
activesheet.protection.alloweditranges(1).delete
activesheet.protection.alloweditranges(1).delete

i hope you could help me with this one. tks.

"Tim Williams" wrote:

....and the code looks like ?

I'm asking partly because I'm not even sure what it is you want to do: posting [a small example] of what you record will help.

Tim


"eehj23" wrote in message ...
have already tried it but if i look at the generated code, it seems that it
uses an array but the index are not in order such as (1), (0), (1), (1)

"Tim Williams" wrote:

Record a macro while going through the steps and look at the generated code.

Tim


"eehj23" wrote in message ...
how can i delete the protection in allow edit ranges via subroutine in
vbscript editor? tks.