Unable to add ListRow to ListObject with worksheet protected using UserInterfaceOnly:=true

Question

I'm trying to add a new row to a table using the ListRows.Add method. The table is on an excel worksheet protected using:

ws.Protect UserInterfaceOnly:=True

I thought this would allow me to add the ListRow without having to unprotect and then re-protect the worksheet, but it doesn't seem to be working. Does anyone know of a workaround for this?

Answer 1

I've experienced this undocumentd feature and, unfortunatetely, the only wokaround I've found is to unprotect the sheet before any table methods are applied and then reprotect after.