Protect/Unprotect VBA Script

**Heat** · 03-18-2013, 07:55 PM

Hi,

I am new to Excel and wanting to know how i can update the below attached document to allow the form to enter informtaion but not allow editing in the LostProperetyTable sheet.

I want the users to only be able to use the form to edit the table not by using the table itself.

I have tried many varieties of coding to protect and unprotect the sheet but the code will not run.

Could someone please assist?

Thank you

**Dunc3142** · 03-19-2013, 12:12 AM

Please Login or Register  to view this content.

Put these lines in your code just before your code puts the data in the data sheet and just after putting the data in the sheet.

**Heat** · 03-19-2013, 01:44 AM

Hi Dunc3142,

Thanks for your help, i have added the code above and below the code but it gets stuck at the first row of inserting the data:

ws.Cells(iRow, 1).Value = Me.txtDate.Value

Please see attached file in case i have added it in the wrong space.

Thanks again for your help!!