protect Excel Sheet in MATLAB

5 views (last 30 days)
Samer Husam
Samer Husam on 27 Jun 2012
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

Accepted Answer

Samer Husam
Samer Husam on 28 Jun 2012
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)

More Answers (1)

Samer Husam
Samer Husam on 28 Jun 2012
is there a function in MATLAB
xlsprotect
can be use?

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!