Lock a named range

  • Thread starter Thread starter lrjanzen13
  • Start date Start date
L

lrjanzen13

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?
 
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
|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
 
Maybe

myrange.mergearea.locked = true


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?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting Error in Micro(for Loop) 6
Code to name numerous ranges 11
Excel 2013 Merge Data 2
Protecting merged cells via Macro 3
unable to set the locked property of the range class 8
Deleting contents from merged cells from VBA 3
Text not looping through ranges 10
Locking all cells of a given color in a given range 6

Back
Top