Code covered by the BSD License  

Highlights from
Protect or unprotect worksheets in Excel file

Be the first to rate this file! 15 Downloads (last 30 days) File Size: 3.83 KB File ID: #42055
image thumbnail

Protect or unprotect worksheets in Excel file

by

 

03 Jun 2013 (Updated )

Protect or unprotect selected worksheets in Excel file, with or without password

| Watch this File

File Information
Description

USAGE
xls_protect_sheets(xlsfile,sheets,action)
xls_protect_sheets(xlsfile,sheets,action,password)

INPUT
- XLSFILE: name of the Excel file
- SHEETS: cell array with the worksheet names, or matrix with positive integers, or 'all', to tell which worksheets are going to be protected
- ACTION: 'protect' or 'unprotect'
- PASSWORD: password to protect or unprotect the worksheet

OUTPUT
- XLSFILE will be edited

Acknowledgements

Check If Xls File Is Open And Close It inspired this file.

Required Products MATLAB
MATLAB release MATLAB 7.10 (R2010a)
Other requirements MS Excel
Tags for This File   Please login to tag files.
Please login to add a comment or rating.
Updates
03 Jun 2013

Added missing function

Contact us