If you post a sample document with the CCs in it, we can create the specific macro but the principle is shown in other threads here.
For instance you could adapt Macropod's code in this post without needing to recreate the wheel.
https://www.msofficeforums.com/128781-post4.html