Allow users to edit ranges

[niknik24]

Hello

I am trying to cretae a code that protects my worksheets but allows users to edit ranges. I want the editable ranges to be 'Named Ranges' from the active sheet.

I have tried simply recording myslef doing this but cannot seem to make it work.

Any help would be appreciated.

Thanks

Nik

 

[SkipVought]

Hi,

You must initially assign the cell Locked property.

Then when you Protect the sheet, the locked/unlocked property will work as prescribed.

Skip,

_[red][/red]

 

[niknik24]

i think i have done that- what would i need to do.

what does the actual code for allowing editing ranges in protection look like?

thanks

Nik

 

[SkipVought]

There is no code. The unlocked cells can simply be edited.

Skip,

_[red][/red]

 

[niknik24]

i think i'm with you now - right click cell format - cell locked or not

thanks v much

Nik

 

[SkipVought]

There you go!

Skip,

_[red][/red]