Protect Worksheet with UserInterfaceOnly still stopping code.

[NickT33]

Hello,

On my sheet I have tables I want users to be able to add / remove / edit data through a form, but have them protected from manual manipulation. After running Worksheets().Protect, UserInterfaceOnly:=True on Workbook_open() it allows my code to edit and remove items, but not add.

The problem seems arise on this line, right after I add a ListRow to the table when I try to add data:

tableRowMain.Range(1, 1).Value = txtDate

I get a Run-time error (1004): Application-defined or object-defined error.

Any help is appreciated.

 

[RoryA]

UserInterfaceOnly is not 100% effective, unfortunately (it never has been), although I'm surprised you can add a new row but not write values to it. Perhaps try explicitly unlocking the cells in the new row first?

 

[NickT33]

I too thought it was odd that there was no problem adding the listrow. If I'm going to unprotect the new row I might as well just do what Joe said and unprotect / protect the sheet at the start and end, I just hope it won't significantly slow down the code. Thanks for the input guys.