How to locked/unlocked cells in an Excel file?

3 次查看（过去 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 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by