VBA学习摘录（破解当前表锁定）_activesheet.protect drawingobjects:=false, content

作者：weixin_40725706 | 2024-03-01 02:49:14

踩

activesheet.protect drawingobjects:=false, contents:=true, scenarios:= _ fal

以下代码摘自EXCELHOME

    ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
      , AllowFiltering:=True, AllowUsingPivotTables:=True
ActiveSheet.Protect DrawingObjects:=False, Contents:=True, Scenarios:= _
      False, AllowFiltering:=True, AllowUsingPivotTables:=True
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:= _
      False, AllowFiltering:=True, AllowUsingPivotTables:=True
ActiveSheet.Protect DrawingObjects:=False, Contents:=True, Scenarios:= _
      True, AllowFiltering:=True, AllowUsingPivotTables:=True
ActiveSheet.Unprotect

解了燃眉之急咯

本文内容由网友自发贡献，转载请注明出处：https://www.wpsshop.cn/w/weixin_40725706/article/detail/170438