theme colors

Due to my disability and medical problems, I have to use Windows dark themes. And therefore the font colour that I use is white on dark background. However, the people with whom I shared my files are usually using light themes which means they need dark font on white background. This issue...

Hello, I was wondering if its possible to use VBA to change the color theme of a worksheet? I am using the code below to create a new workbook and copy worksheets into this workbook from another workbook. Unfortunately, the workbook color theme in my initial workbook is set on "Violet" -...

I am copying selected sheets from a workbook to a new workbook so that I can publish it with values only. when I do this in Excel 2013 (the workbook was created in a prior version of Excel), it automatically adjusts my cell fill colors to the new 2013 theme colors. I want it to keep my old...

In my macro, I utilize conditional formatting to create alternating rows of color. The powers that be have tired of the sage green I've been using. How do I easily change the color in the following piece of code? Say I want to change it to pink, and then later on I change my mind and want to set...