April 2006
Beginner
1114 pages
98h 16m
English
alloweditrange.Delete( )
Removes an edit range from a worksheet. For example, the following code deletes all the edit ranges in a worksheet:
Set ws = ThisWorkbook.Sheets("Protection")
For Each aer In ws.Protection.AllowEditRanges
aer.Delete
NextRead now
Unlock full access