How to locked/unlocked cells in an Excel file?

6 次查看（过去 30 天）
Jurij Rici
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

请先登录，再回答此问题。

回答（1 个）

dpb
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.

类别

在 Help Center 和 File Exchange 中查找有关 Use COM Objects in MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by