Protecting a range

[mikeymay]

Why does

Selection.Locked = False

work when setting a ranges format to 'Locked' on the 'Protection' tab, but when using a named range (for the same range as 'Selection' above) doesn't work

Range("Summary_Branch").Locked = False

Ideally I want to protect the named range without having to activate the sheet and select the range.


Thanks

 

[lenze]

If you are on another sheet when you run the code, you will have to refer to the target sheet!! With your range to protect on sheet 2, you would need something like this!

Sheets("Sheet2").Range(""Summary_Branch").Locked = False

lenze