Lock a named range
 

I have a named range (='Site Limiting Factors'!$J$10) that defines a named
range for several merged cells. When I call MYRange.Lock I get an error
"Cannot change part of a merged cell." How do you lock and protect a Merged
cell?
--
Thanks
Lonnie

Lock a named range
 

Merged cells are a pita. If you can change the name's definition have it
refer to all cells in the merge. If not, create a new name to do that.

--
Jim
"lrjanzen13" wrote in message
...
|I have a named range (='Site Limiting Factors'!$J$10) that defines a named
| range for several merged cells. When I call MYRange.Lock I get an error
| "Cannot change part of a merged cell." How do you lock and protect a
Merged
| cell?
| --
| Thanks
| Lonnie

Lock a named range
 

Maybe

myrange.mergearea.locked = true



lrjanzen13 wrote:

I have a named range (='Site Limiting Factors'!$J$10) that defines a named
range for several merged cells. When I call MYRange.Lock I get an error
"Cannot change part of a merged cell." How do you lock and protect a Merged
cell?
--
Thanks
Lonnie

--

Dave Peterson