Sub 保护工作表()
For Each one In Worksheets
one.Select
ActiveSheet.Protect Password:=123456#, _
DrawingObjects:=True, _
Contents:=True, Scenarios:=True
Next one
End Sub
把这段代码放入你的EXCEL模块中即可
Sub 保护工作表()
For Each one In Worksheets
one.Select
ActiveSheet.Protect Password:=123456#, _
DrawingObjects:=True, _
Contents:=True, Scenarios:=True
Next one
End Sub
把这段代码放入你的EXCEL模块中即可
我不知道呀 发表于 2011-2-19 10:31
Sub 保护工作表()
For Each one In Worksheets
one.Select
测试了一下,比较好用,要运行一下宏,
密码是123456吧
要是我不要密码,是不是只要删除123456就行了,比如成为下面的
Sub 保护工作表()
For Each one In Worksheets
one.Select
ActiveSheet.Protect Password:=#, _
DrawingObjects:=True, _
Contents:=True, Scenarios:=True
Next one
End Sub
Sub 保护工作表()
For Each one In Worksheets
one.Select
ActiveSheet.Protect Password:="", _
DrawingObjects:=True, _
Contents:=True, Scenarios:=True
Next one
End Sub