| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
allow edit ranges protection
how can i delete the protection in allow edit ranges via subroutine in
vbscript editor? tks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sheet Protection / Edit Objects | Excel Worksheet Functions | |||
| Sheet Protection / Edit Objects | Excel Worksheet Functions | |||
| WS Protection: Different Levels of Protection on Different Ranges | Excel Discussion (Misc queries) | |||
| protection / edit ranges | Excel Discussion (Misc queries) | |||
| Allow user to edit Ranges under "Protection" | Excel Programming | |||
Hybrid Mode
