Hello everybody,
This is my 1st post, so I hope I can make it clear.
I have a Workbook which contains of 15 Sheets. Each Sheets consists of:
1. Formulas. {Which I don't want anyone to mess with them}
2. Ranges "Group 1" in every Sheet. {Which I need ONLY Team 1 to be able to edit them}
3. Ranges "Group 2" in every Sheet. {Which I need ONLY Team 2 to be able to edit them}
The easy part for me was:
1. Assign a Macro to Protect all Sheets and linked it to a custom icon in the Ribbon. {Using "CustomUIEditor"} To be able to Protect all Sheets by 1-Click. {Password "ABC"}
2. Assign a Macro to Unprotect all Sheets and linked it to a custom icon in the Ribbon. {Using "CustomUIEditor"} To be able to Unprotect all Sheets by 1-Click.
3. Setting "Allow Users to Edit Ranges" with Password "1" for Team 1 in every Sheet.
4. Setting "Allow Users to Edit Ranges" with Password "2" for Team 2 in every Sheet.
What I need is to be able to run macros to:
1. Unlock all the Ranges "Group 1"
2. Unlock all the Ranges "Group2"
So, my question is:
Is there is a code to unlock those cells within the "Allow Users to Edit Ranges" ?
{Sorry, for the long explanation, just needed to be sure it's clear. Thanks in advance.}
Bookmarks