Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Protection.AllowEditRanges
How should I delete all the ranges in Protection.AllowEditRanges using
VBA. I am not getting the index of each of the items to delete. Mangesh --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Protection.AllowEditRanges
Hello!
I do not fully understand what you want to do, but you can enumerat all AllowEditRanges and then use the Delete-method .... Dim s As Worksheet Dim rng As AllowEditRange Set sh = ActiveSheet For Each rng In sh.Protection.AllowEditRanges rng.Delete Next rng Ro -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Protection.AllowEditRanges
Thanks. I am doing something similar at the moment. My initial proble
was that I was not getting the item nos to delete it. But later on figured out. Thanks anyway. Manges -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Protection and Delete Modules | Excel Discussion (Misc queries) | |||
Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
Protection-exceptions to delete a row | Excel Worksheet Functions | |||
VBA code delete code but ask for password and unlock VBA protection | Excel Programming |