Protecting cells with a particular 'style'

[meherts]

Hello all,

I was wondering if there was a way to ONLY protect cells with a particular 'style', such as "Background", "Section", and "Title" and to leave the remaining cells unprotected.

Thanks,
Mark

[shg]

Format the style to include Protection = Locked, format the other styles as unlocked, and protect the worksheet.

[meherts]

Well, I believe I've found a viable solution. That is, I went to Tools -> Protection -> Allow Users to Edit Ranges and chose the ranges I wanted to be editable.

If you have another solution, please post!

[meherts]

That worked beautifully too, thanks!

[shg]

Doing it by style as in your original approach is superior, IMO.