Forum Discussion
JulienTheriault
Aug 03, 2022Brass Contributor
Full Dark Mode in Excel
Currently you can set Office Theme to Black which acts as a dark mode. In Word, setting this to Black makes the page dark and the text white when it is set to “Automatic”. I was wondering if anyo...
mamachugh
Oct 17, 2023Copper Contributor
AdrianParker Thank you so much!
BXavier
Mar 09, 2024Copper Contributor
Okay so in reviewing, it looks like this macro will do a nice job of changing colour of the worksheet to dark mode - but when it's time to print something, we're CERTAINLY not going to want to print what we're seeing on the screen! So if I want to work in dark theme/mode but print in a "normal" view, I'm going to have to toggle each and every time I want to print my worksheet? This is not a good workaround for the scenario outlined here. I too struggle to work on documents that have a glaring white background with dark text, and with Word and Outlook I don't have to - and when I need to print an email or Word document, it automatically prints it in "standard" acceptable formats. How do we create a macro that will apply the appropriate stylings to an Excel worksheet BUT still prints with a white background and black text??? THIS is the solution that is truly needed in order to be functional in practical applications...
- JKPieterseMar 11, 2024Silver ContributorAs long as Microsoft hasn't added a dark mode for Excel you are stuck with the only workaround I think is a little feasible: Settings Windows to high contrast mode, using the High contrast Black theme. That will affect the way everything in Windows is displayed, but it will leave your print unchanged. But I doubt if this is what you want to use 🙂