Excel VBA 2001-12425 UserInterfaceOnly:= True has partial effect on letting Macros change protected sheets
Reference a previous suggestion, https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/11050386-worksheet-protection-userinterfaceonly-setting-s , the VBA function seems to be broken. Although set for specific worksheets at Workbook_open, macro execution get blocked on relevant sheets because protection is set. The password is uniform across the workbook, so still needing to execute a slowing unprotect, which risks the sheet become accessible for modification if the relevant macro fails.
Oddly, unless the UserInterfaceOnly is set during Workbook open, the ,UserInterFaceOnly:=only is declared illegal in the relevant module while reprotecting the sheet during code compiling.
Edit: Specifically, of the various cases, a Run-time Error '3000' occurs when working with tables on protected sheets, "Table features aren't available because the sheet is protected".