How to locked/unlocked cells in an Excel file?

3 vues (au cours des 30 derniers jours)

Jurij Rici le 21 Août 2024

Commenté : Image Analyst le 21 Août 2024

Dear,

how can I lock/unlock cells in Excell file?

For example: file = 'Fruits.xlsx', Sheet = 'Apple', Range = 'B4:B10'.

How is possible to lock the cells in range 'B4:B10' in my file and my sheet? The file and the sheet are unprotected.

Thank you very much? Jurij Rici

dpb le 21 Août 2024

You'll have to use Excel COM. The <Link to Excel Locked Property> gives the syntax; you merely set the range .Locked property to true/false.

Image Analyst le 21 Août 2024

Some files that may help are attached. Good luck. These use ActiveX so require Windows, not mac iOS.

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

En savoir plus sur Spreadsheets dans Help Center et File Exchange

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

Translated by