When I open a workbook, cell protection is not fully active

D

Dave_B_at C&W

I have activate worksheet protection that prevents selecting "Protected"
cells, but when I open the workbook again, I can still select the cells but
just not change them. If in uprotect and reprotect the worksheet, I am then
not able to select the protected cells.

I only have the "select uprotected cells" option ticked when activating the
protection.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top