Delete AllowEditeRange by VBA command
Solved/Closed
Related:
- Delete AllowEditeRange by VBA command
- Delete AllowEditeRanges by VBA ✓ - Forum - Excel
- How to clear contents in excel without deleting formulas using vba ✓ - Forum - Excel
- Adding a VBA Command Button - How-To - Excel
- Delete ALL AllowEditRanges in command Button ✓ - Forum - Programming
- Delete command in laptop - Guide
1 reply
TrowaD
Apr 21, 2011 at 09:26 AM
- Posts
- 2888
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- August 16, 2022
Apr 21, 2011 at 09:26 AM
Hi Celina,
Added this codeline: ws.select
Now your code looks like:
Best regards,
Trowa
Added this codeline: ws.select
Now your code looks like:
Sub test() Dim WS As Worksheet Dim aer As AllowEditRange For Each WS In Worksheets WS.Select For Each aer In ActiveSheet.Protection.AllowEditRanges aer.Delete Next aer Next WS End Sub
Best regards,
Trowa
Apr 26, 2011 at 07:00 AM
Thank you very much, it works perfect.
Best regards,
Celina