MATLAB: Protect Excel Sheet in MATLAB

excellock sheet

hi; I have some values that is saved in Excel by MATLAB. so I want to lock or protect the sheet before its been open to the user to not allow the use to edit it. is there any way to do this ? please help and advice. thanks
Sam

Best Answer

   xlsprotect(file,'protect_file',pwd2open,pwd2modify,read_only_recommended,create_backup)
 xlsprotect(file,'unprotect_file',pwd2open) 
 xlsprotect(file,'unprotect_file',pwd2open,pwd2modify)
 xlsprotect(file,'protect_sheet',sheetname,password) 
 xlsprotect(file,'protect_sheet',sheetname,password,s_options) 
 xlsprotect(file,'protect_sheet',sheetname,s_options) 
 xlsprotect(file,'protect_sheet',sheetname)
 xlsprotect(file,'unprotect_sheet',sheetname) 
 xlsprotect(file,'unprotect_sheet',sheetname,password)
 xlsprotect(file,'protect_workbook',password) 
 xlsprotect(file,'protect_workbook')
 xlsprotect(file,'unprotect_workbook') 
 xlsprotect(file,'unprotect_workbook',password)
Related Question