Submit data entry into the protected sheet without being able to edit by the user,is it possible?

[megna]

Hi everyone...

I have created a simple userform that is linked to a button on sheet1. When the data in the userform is submitted, I set it up so it goes into a database under sheet2. The problem is, I don't want anyone modifying the entries in the database. Usually I would protect the sheet with a password, but when I do that, there is an error when the userform is submitted. The only thing I can think of is to hide sheet2, which doesn't seem like a great solution.

Is there any way to protect my database from being modified yet still allow the userform to be linked to it?

Thanks, and I hope this makes sense

 

[Jaye7]

You can modify the following script so that when you call your userform you unprotect your sheet and then when the code has finished running you then protect the sheet.

Sub ProtectSheet()
Dim Password    'This line of code is optional
Password = "1234"
ActiveSheet.Protect Password, True, True, True
'Add in the following line if you want the user
'to be able to select the cell but not change anything
'ActiveSheet.EnableSelection = xlNoRestrictions
End Sub


Sub UnProtectSheet()
Password = "1234"
ActiveSheet.Unprotect Password
End Sub

 

[megna]

Thank you very much dear.My coding was working perfectly but all of a sudden I can't even lock the sheet as usual. Any idea why?Thanks again

 

[Jaye7]

If it isn't working then either it is already locked or somewhere along the line you have entered wrong code.

If you want you can send me a dummy copy of your workbook with any sensitive data removed and I can have a look at it.

If you want me to look at the code then you can send me a private message through this site and I will then give you my email address.