I'm having trouble finding a solution to this problem. Basically, I build a bunch of workbooks for colleges and I like to have the colors match the school colors as much as I can. I can make themes for each school, but eventually I lock off a bunch of formatting functionality, so the end result is making a new workbook for each school. Ideally, I would like run a vba script that changes the text/background light 2 and text/ background dark 2 to RGB values in the workbook (that way I can just change those as needed rather than make new themes for each organization. Any ideas? Thanks a ton!
-
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.
Setting Theme Colors based on RGB Values in the active workbook
Similar threads
- Solved
