Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reduce a range to just be the part within another part?
Hi,
I have a protected sheet with range of cells the user can edit. On the change event, for each cell in target I restore some formats with a loop - if it insersect the range of cells allowed. However, if the user insert a row or column, the code will check all cells in the column. This is not acceptable, of cource. However, I want the user to be able to insert rows and columns, so I can't restrict that together with the sheet protection. What is the best way to solve this? I don't want to use looping and for each cell check if it intersect - and if so, Union it to a new range. Is there any other way? Happy to all answers, Regards tskogstrom |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reduce a range to just be the part within another part?
Hi ,
May be you can make it done by Unprotect before insert and protect them again after insert like: ActiveSheet.Unprotect Rows(1).insert ActiveSheet.Protect -- Regards, Halim "tskogstrom" wrote: Hi, I have a protected sheet with range of cells the user can edit. On the change event, for each cell in target I restore some formats with a loop - if it insersect the range of cells allowed. However, if the user insert a row or column, the code will check all cells in the column. This is not acceptable, of cource. However, I want the user to be able to insert rows and columns, so I can't restrict that together with the sheet protection. What is the best way to solve this? I don't want to use looping and for each cell check if it intersect - and if so, Union it to a new range. Is there any other way? Happy to all answers, Regards tskogstrom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
spreadsheet part and part without grid lines | Excel Discussion (Misc queries) | |||
Countif range contains part of a value | Excel Worksheet Functions | |||
Search/Match/Find ANY part of string to ANY part of Cell Value | Excel Worksheet Functions | |||
Copying Part of a row down part of a column | Excel Discussion (Misc queries) | |||
How can I sperate the module into two part and connecte the two part and work well? | Excel Programming |