返回
AllowEditRanges
对象。
语法
表达式.AllowEditRanges
表达式 一个代表 Protection 对象的变量。
示例
在本示例中,ET 允许用户编辑活动工作表上的区域 A1:A4,并将指定区域的标题和地址通知用户。
示例代码 |
function UseAllowEditRanges(){
let wksOne = Application.ActiveSheet
let strPwd1 = prompt("Enter Password")
// Unprotect worksheet.
wksOne.Unprotect()
// Establish a range that can allow edits on the protected worksheet.
wksOne.Protection.AllowEditRanges.Add("Classified", Range("A1:A4"), strPwd1)
//Notify the user the title and address of the range.
let WKSone = wksOne.Protection.AllowEditRanges.Item(1)
MsgBox("Title of range: " + WKSone.Title)
MsgBox("Address of range: " + WKSone.Range.Address)
}
|