Gabriel

G

gszabo

New Member
Joined
Dec 14, 2010
Messages
4
I have made an Excel form to enter data some cells by users. I want to protect the format of whole sheet (colors, validations, etc.) in all cells (even those where the user can enter data). The problem is when I lock a cell the user can not enter data but when I do not lock a cell the user can change the format and validation of cell.
How to create a sheet where the user can only do to enter data some cells and no more.
 
Sort by date Sort by votes
Select the cells where users can enter data, then Format > Cells > Protection tab > untick Locked. Then protect the sheet.
 
Upvote 0
select a cell that is to be used for user and goto Format>cells>protection and unprotect those cells. then protect the sheet
 
Upvote 0
As I mentioned if I unlock a cell the user can do anything with the cell not only fill it. Even can change the validation.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Solved
Count Number of Cells With Non-Matching Values
Replies
3
Views
112
Eric W
Eric W
J
  • Solved
Enter multiple lines of text and auto-fit row height
Replies
6
Views
240
judgejustin
J
hicksi
  • Question Question
Ensuring a Form is Activated
Replies
1
Views
149
NdNoviceHlp
NdNoviceHlp
H
  • Question Question
VBA to protect/unprotect sheet...
Replies
6
Views
820
jkpieterse
jkpieterse
P
  • Solved
Conditional Format Selected Cell
2
Replies
12
Views
381
Pacman52
P

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