Ok, hopefully this can actually be done. When I’m in excel and click the ‘Fill’ or ‘Text Color’ drop down, I am presented with ‘Theme Colors’ which displays the matrix of 10 colors and then 5 rows of corresponding hues, and ‘Standard Colors’. In my line of work, the consistency with colors used is critical and although I can easily click on more colors to select the one I need, I would like to just have my preset most commonly used colors available when excel opens each time. This is the same scenario for MS Word. I often open different excel workbooks of varying versions and would like to do something so that the colors I always use are always at the ready. Can anyone provide any advice? Avoiding macros would be best just because of possible conflicts with other proprietary software interacting with my MS Office products already but it’s not out of the question. I understand and can write VBA but I’m not sure how to solve this guy. Thanks
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
