How to locked/unlocked cells in an Excel file?

조회 수: 3 (최근 30일)

Jurij Rici 2024년 8월 21일

댓글: Image Analyst 2024년 8월 21일

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 2024년 8월 21일

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 2024년 8월 21일

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

Help Center 및 File Exchange에서 Use COM Objects in MATLAB에 대해 자세히 알아보기

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

Translated by