try unlocking the worksheet first then relocking it

--
When you lose your mind, you free your life.
Ever Notice how we use '' for comments in our posts even if they aren''t
expected to go into the code?


"dorre" wrote:

Hi

I have columns that are normally locked with protection on. But, I need to
have code that allows me to temporarily unluck column N. Why do I get an
error (1004: unable to set the locked property of the range class) with
this code?

Activesheet.Columns("N:N").Select
Selection.Locked = False

thanks
dorre