Protect or unprotect worksheets in Excel file

Versión 1.1.0.0 (3,83 KB) por Guilherme Coco Beltramini
Protect or unprotect selected worksheets in Excel file, with or without password
0.0
(0)
680 descargas
Actualizado 3 jun 2013

Ver licencia

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

Citar como

Guilherme Coco Beltramini (2024). 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. Recuperado .

Compatibilidad con la versión de MATLAB
Se creó con R2010a
Compatible con cualquier versión
Compatibilidad con las plataformas
Windows macOS Linux
Agradecimientos

Inspirado por: Check if XLS file is open and close it

Community Treasure Hunt

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

Start Hunting!

Versión Publicado Notas de la versión
1.1.0.0

Added missing function
1.0.0.0