notuserfriendly
Programmer
Hi Im protecting my sheet by
However I'm wondering how to being able to change the
rights to select protected cells.
/I
Code:
ThisWorkbook.Sheets(Sheet).Protect Password:="pass", _
AllowInsertingRows:=True, _
AllowFormattingRows:=True, _
AllowDeletingRows:=True, _
AllowInsertingColumns:=False, _
AllowFormattingColumns:=False, _
AllowDeletingColumns:=False, _
AllowFormattingCells:=True, _
AllowSorting:=True, _
AllowFiltering:=True, _
AllowInsertingHyperlinks:=True, _
AllowUsingPivotTables:=False
However I'm wondering how to being able to change the
rights to select protected cells.
/I