Worksheet Protection Question

P

Pat

I have a worksheet where I want to lock cells and unlocked.

After I protect the sheet....

-I want to be able to have users input data in unlocked cells
-I want users to be able to select certain locked cells
-I also want users to NOT be able to select certain locked cells

Is this possible? If yes, how?
 

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

Similar Threads

Locking by multiple users possible? 0
Enabling Autofilter and Sorting in a Protected Sheet 2
Locked cells are still able to be selected with proper protection 1
How to change format protection default to unlocked? 2
David Biddulph is correct 8
cell locking and sheet protection 0
protection 2
Can't lock cells 4

Top