Selecting only Unlocked Cells

prajul89

prajul89

Active Member
Joined
Jul 9, 2011
Messages
404
Is it possible to Lock only some cells from being selected by user?
I have tried unchecking 'Select Locked Cells' in Protect Sheets, But it disable selecting every cells(including the range I have Selected 'Allow user to edit Ranges').
 
Sort by date Sort by votes

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
You must log in or register to reply here.

Similar threads

A
  • Question Question
VBA help - Locking & unlocking on certain times of day
2
Replies
17
Views
456
dmt32
D
A
  • Solved
excel protected sheet - some cells are unlocked for user input getting cleared on click
Replies
3
Views
135
AgentBaadal
A
S
  • Question Question
Cannot Tab in Locked Excel Form
Replies
5
Views
76
6StringJazzer
6StringJazzer
K
  • Question Question
Tab key selects unlocked cell to the right of a dropdown list
Replies
4
Views
151
Kc3475
K
J
  • Question Question
Macro to "Finalize" and lock a workbook
Replies
2
Views
164
JimmyHack
J

Forum statistics

Threads
1,224,587
Messages
6,179,741
Members
452,940
Latest member
rootytrip

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top