Hi,

I have a sheet where I want to protect a cell so it can't be modified, so I locked the cells in question, but then I have a macro that selects a range with the locked cells within it and I get a runtime error on the macro. I'm assuming because it can't select the range with the locked cells in it. On my protection specifications I added the permission to select locked cells, but it still gave me the runtime error.

Is there a way around this? I'd like to run my code and also keep a few cells protected that I need to.

Thanks!