G Guest Apr 20, 2006 #1 how can i delete the protection in allow edit ranges via subroutine in vbscript editor? tks.
T Tim Williams Apr 20, 2006 #2 Record a macro while going through the steps and look at the generated code. Tim
G Guest Apr 24, 2006 #3 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)
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)
T Tim Williams Apr 24, 2006 #4 ....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
....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
G Guest Apr 26, 2006 #5 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 said: ....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 said: 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) Click to expand... Click to expand...
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 said: ....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 said: 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) Click to expand... Click to expand...
