|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
本帖最后由 半花 于 2016-6-17 14:36 编辑
Cells.Select
Range("AB14").Activate
Selection.Locked = False
Selection.FormulaHidden = False
Selection.SpecialCells(xlCellTypeFormulas, 23).Select
Selection.Locked = True
Selection.FormulaHidden = True
ActiveSheet.Protect DrawingObjects:=False, Contents:=True, Scenarios:= _
False, AllowFormattingCells:=True, AllowFormattingColumns:=True, _
AllowFormattingRows:=True, AllowInsertingColumns:=True, AllowInsertingRows _
:=True
Range("AB10").Select
ActiveWorkbook.Save
End Sub
这个是录制得到的宏,求修改加上锁定密码“123456”拜谢!!!!!~~~来人啊,,,,救命啊~~~~~~大神们,老师们,,,求帮帮我啊~~~
|
|