Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Disabling selection of protected cells? 1

Status
Not open for further replies.

notuserfriendly

Programmer
May 7, 2004
82
SE
Hi Im protecting my sheet by

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top