Hello people.
I would like to know how can i change a file name taking into account an if condition.
Therefore, in specific:
1. The purpose of the code is oriented to, if i don't have the file open, i can see its name and realize that something changed or not in the sheet;
2. The condition is supposed to be definied by the cell color, so, if at least one cell of a group of cells have a specific color (that's defined by conditional formatting) then the name would change and would include a letter, a character or something else, to signal that the sheet needs changes;
3. Once the changes were made and the condition was not checked, the file would be renamed again to the original name;
If somenone can help me, i would appreciate.
Thank You in advance.
BR
I would like to know how can i change a file name taking into account an if condition.
Therefore, in specific:
1. The purpose of the code is oriented to, if i don't have the file open, i can see its name and realize that something changed or not in the sheet;
2. The condition is supposed to be definied by the cell color, so, if at least one cell of a group of cells have a specific color (that's defined by conditional formatting) then the name would change and would include a letter, a character or something else, to signal that the sheet needs changes;
3. Once the changes were made and the condition was not checked, the file would be renamed again to the original name;
If somenone can help me, i would appreciate.
Thank You in advance.
BR