Hi
What would you suggest to launch VBA macro to change theme(Dark) when excel opens ?
Thank you
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Launch macro to change theme when excel opens
0
Discussion
Carlo
Do you mean an Excel theme (which you might pick from the Page Layout tab of the Ribbon) or an Office theme? Latter might only be possible using SendKeys.
Do you mean an Excel theme (which you might pick from the Page Layout tab of the Ribbon) or an Office theme? Latter might only be possible using SendKeys.
John_Ru (rep: 6142) Nov 7, '21 at 10:19 am
Hi John_Ru
I meant Office theme.
Latter, sendkeys...Whatever you think is the best vba solution will be much appreciated.
BTW, I'm pretty new to Excel VBA.
Thanks for being kind and patient.
I meant Office theme.
Latter, sendkeys...Whatever you think is the best vba solution will be much appreciated.
BTW, I'm pretty new to Excel VBA.
Thanks for being kind and patient.
Carlo (rep: 6) Nov 7, '21 at 12:09 pm
I'll see if I have time tomorrow to experiment. Assume that once Excel closes you want the Office theme to return to what it was, right?
John_Ru (rep: 6142) Nov 7, '21 at 12:19 pm
A msgbox would propose "A better exerience with Office dark Mode/theme".
A msgbox would propose to "keep the Office dark Mode/Theme once Excel closes"
NB. The Excel file will have dark Headers and white text, dark tables...So, Dark Ofiice will be much better for the eyes.
A msgbox would propose to "keep the Office dark Mode/Theme once Excel closes"
NB. The Excel file will have dark Headers and white text, dark tables...So, Dark Ofiice will be much better for the eyes.
Carlo (rep: 6) Nov 7, '21 at 12:58 pm