Locking a cell after data entry (Excel 2003)

J

jeffparker98

Hello,
How can I format a cell so that is it locked after data entry? I'm trying to
set up a simple data entry form where the user cannot change their input once
they press enter (they are required to show changes in the cell below).

Thanks!
Jeff
 

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

Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
force entry in cell "B" if entry made in cell "A" 1
Locking by multiple users possible? 0
External cell reference between two excel worksheets both in One Drive 0
Locking a format 1
Data Validation - Prevent delete 2
Forcing entry into validation cell 1
Prompted data entry 0

Top