unlocking problem

  • Thread starter Thread starter dorre
  • Start date Start date
D

dorre

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
 
I assume the sheet is protected, so you need to unprotect it to change the
locked property

Activesheet.Unprotect
ActiveSehet.Columns("N:N").Locked = False
Activesheet.Protect


If you are just trying to work with the cells using code, you might use the
interfaceonly property - only setable via code.

Activesheet.Protect UserInterfaceOnly:=True

This should avoid the need to unlock the cells. If you want to allow user
access, then see the first suggestion.
 
Back
Top