The status UserInterfaceOnly:=TRUE
is unfortunately not stored in the file – therefore, if you reopen the file, it will be fully protected. Either use the Workbook_Open
event to reapply this protection status – or unprotect and then reprotect the worksheet in your VBA code directly.
See Ozgrid for further details!