157Studios
New Member
- Joined
- Sep 3, 2013
- Messages
- 6
Hello,
I'm looking for a way to have excel cells lock after an entry is made. I need it to work on several worksheets. I'm creating a file that will have a worksheet for every day of the month and the file will be for one month (31 Sheets). Each sheet is named 1-31 respectfully. I will have 6-8 colums in each sheet that will need to be able to be locked after the entry. I want this so that when someone presses enter after making an entry, it is no longer able to be edited without a password in which they won't know. This way no information can be altered or erased once it's in the cell. I need this to work starting at row 3 as 1 and 2 will be titles that may be changed in the future.
I'm new to these methods so any help is appreciated. Thanks in advance.
I'm looking for a way to have excel cells lock after an entry is made. I need it to work on several worksheets. I'm creating a file that will have a worksheet for every day of the month and the file will be for one month (31 Sheets). Each sheet is named 1-31 respectfully. I will have 6-8 colums in each sheet that will need to be able to be locked after the entry. I want this so that when someone presses enter after making an entry, it is no longer able to be edited without a password in which they won't know. This way no information can be altered or erased once it's in the cell. I need this to work starting at row 3 as 1 and 2 will be titles that may be changed in the future.
I'm new to these methods so any help is appreciated. Thanks in advance.
