File Exchange

image thumbnail

Protect or unprotect worksheets in Excel file

version 1.1 (3.83 KB) by

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

3 Downloads

Updated

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

Comments and Ratings (0)

Updates

1.1

Added missing function

MATLAB Release
MATLAB 7.10 (R2010a)
Acknowledgements

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

Download apps, toolboxes, and other File Exchange content using Add-On Explorer in MATLAB.

» Watch video

Win prizes and improve your MATLAB skills

Play today