How to lock/protect a cell that is selected in a macro range

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!

OK. On the code snippet if I already have a sub I can just drop in the "Sheets" lines? Thanks!

Yup. Just put one line at the top and the other at the bottom. With your code inbetween.

Ok.Thanks!

Hi Stnkynts,
Can you tell me if this approach (adding the sheets.Unprotect and sheets.Protect code) would work if the macro was within the Personal XLSB workbook. Would you need to specify to use the active workbook for example?

Please Login or Register  to view this content.

My apologies in advance if this should be in a new post, but it seemed very closely related...

@fur. It should be a new post. But to answer your question, are you sure that one of your sheets (tab) is named "Sheet1". That is probably what is giving you this error.

Thanks for your reply, yes my macro was calling for "Sheet1" while the actual sheet name had been changed to "Data". Error message resolved once the names were matched up.
Many thanks!