Skip to content

Instantly share code, notes, and snippets.

@nobrinskii
Created April 4, 2012 11:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nobrinskii/2300488 to your computer and use it in GitHub Desktop.
Save nobrinskii/2300488 to your computer and use it in GitHub Desktop.
[vba/excel] エクセルのシートを保護する
ActiveSheet.Protect DrawingObjects:=False, _
Contents:=True, _
Scenarios:=False, _
AllowFormattingCells:=True, _
AllowFormattingColumns:=True, _
AllowFormattingRows:=True, _
AllowInsertingColumns:=True, _
AllowInsertingRows:=True, _
AllowInsertingHyperlinks:=True, _
AllowDeletingColumns:=True, _
AllowDeletingRows:=True, _
AllowSorting:=True, _
AllowFiltering:=True, _
AllowUsingPivotTables:=True
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment