File Exchange

image thumbnail

Protect or unprotect worksheets in Excel file

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

4 Downloads

Updated 03 Jun 2013

View License

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

Cite As

Guilherme Coco Beltramini (2020). Protect or unprotect worksheets in Excel file (https://www.mathworks.com/matlabcentral/fileexchange/42055-protect-or-unprotect-worksheets-in-excel-file), MATLAB Central File Exchange. Retrieved .

Comments and Ratings (0)

Updates

1.1.0.0

Added missing function

MATLAB Release Compatibility
Created with R2010a
Compatible with any release
Platform Compatibility
Windows macOS Linux
Acknowledgements

Inspired by: Check if XLS file is open and close it