Capturing info using VB form onto excel

I would be extremely grateful if any of the experts in MS Excel could help me out with my problem. I have gone through all the previous questions to find out if a similar question was raised earlier and could not spot out any. I genuinely need help with the following problem:

I have created a user form in excel to capture information on to a particular sheet. This is done using VB6 that supports the version of MS Excel 2002 that is installed on my system. There is a command button on the sheet to which this macro has been assigned and each time the user clicks on to this button, the form opens enabling him to input information. There are three command buttons on my VB form viz. “Add new”, “Clear all” and “Exit form” in addition to other text boxes etc. Thus the form only enables the user to enter data and not to delete or edit data that has already been entered in the worksheet.

Now, my problem is that I need to ensure that the user does not enter information directly onto the worksheet. He should do it only through the form. Also, he should not be able to edit information that has already been entered in the worksheet. In case he finds that he has made a wrong entry he should only be able to delete the entire row corresponding to that entry in the worksheet directly but resubmit the information only through the VB form. If I try to protect the worksheet so as to not allow the user to access the worksheet, the problem is that the data from the user form also does not get written onto the worksheet. How do I solve this problem?

Hi Lilly
YOu can do so simply by protecting a worksheet.Select all cells in excel worksheet that you dont want users to change.Right click and click on format cells
In the protection select both option 1.Hidden and Locked.
Then Protect the sheet and remember password.
And in vb form when you want to access this sheet
Dont forget to used Unprotect sheet with unprotect command and also mention password there.I am talking about vb 2010 .I dont know weather it works for vb 6
IF you further need help Please email me at imti321@gmail.com