It seems Marvel has ditched Google’s Pixel phones for a Nokia Lumia running Windows 10 Mobile. I wasn't able to figure out a way to change the IDE colors using code, so I just do it manually using Tools>Options>Editor Format. Trading up the Endgame Google Pixel for a Nokia running Widows 10 Mobile. Font.ThemeColor = xlThemeColorDark1 'text colorįor Each border In borderTypes 'border color Interior.ThemeColor = xlThemeColorLight1 'cell color If r.Interior.ThemeColor = xlThemeColorDark1 Then dark = True

Set r = sh.Range('A1') 'toggle color based on A1 of each sheet XlEdgeRight, xlInsideVertical, xlInsideHorizontal) Sub darkModeToggle()ĭim sh As Worksheet, r As Range, dark As Booleanĭim borderTypes As Variant, border As VariantīorderTypes = Array(xlEdgeLeft, xlEdgeTop, xlEdgeBottom, _ Almost all the 'black' iconography default Windows themes is actually dark gray, so you quickly notice the difference when using NUXV. Because its black and white, its incredibly striking. The code uses the background color in cell A1 of each sheet to determine how to toggle the colors. NUXV is another minimalist theme that strips out all hint of color. I use the following Excel VBA code to toggle all sheets in a workbook between Dark Mode and Light (default) Mode.