Delete ALL AllowEditRanges in command Button
Solved/Closed
Issa
-
Apr 14, 2011 at 12:49 PM
rizvisa1
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Delete ALL AllowEditRanges in command Button
- Excel vba add command button programmatically - How-To - Excel
- Excel VBA add command button programatically - Guide
- Creating search and update command buttons in a userform ✓ - Forum - Excel
- VBA code for command button ✓ - Forum - Excel
- VBA code in my command button doesn't work ✓ - Forum - Excel
1 reply
rizvisa1
Jul 3, 2011 at 08:24 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Jul 3, 2011 at 08:24 AM
Change this line
ActiveSheet.Protection.AllowEditRanges
to
WS .Protection.AllowEditRanges
ActiveSheet.Protection.AllowEditRanges
to
WS .Protection.AllowEditRanges