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.

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

Help Center および File Exchange で Spreadsheets についてさらに検索

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

Translated by