I'm using Excel 2013
I want to know if it is possible to protect a worksheet and allow a user to resize a table using VBA.
I have added the following code to the workbook open sub:
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.Protect Password:="abc", UserInterFaceOnly:=True
Next ws
When the VBA to resize the table is called I get an error:
"Cannot use this table functionality on a protected sheet"
I was hoping that UserInterfaceOnly could be used as I don't want Unprotect the sheet, apply the table changes, then re-protect the sheet because of the slow performance of the Protect operation in Excel 2013
Bookmarks