Chewwbutta
New Member
Hello! I'm trying to develop a global solution for my team where we utilize a set palette of colors and font style. I have been able to create the theme on my machine, and have transferred both the .XML and .THMX files to another machine and through VBA apply the theme.
My problem is that this is not a great global solution for >200 users. I was hoping to be able to take the .XML and .THMX code and package it into an excel addin or module? I would even be willing to hard code the colors for the palette and font for the theme into a module, but I am unable to get the
line to work properly.
Does anyone have any experience with implementing this in Excel 2016? I'm open to any and all ideas!
Thank you in advance for your time reading this.
My problem is that this is not a great global solution for >200 users. I was hoping to be able to take the .XML and .THMX code and package it into an excel addin or module? I would even be willing to hard code the colors for the palette and font for the theme into a module, but I am unable to get the
Code:
ActiveWorkbook.Theme.ThemeColorScheme.LoadDoes anyone have any experience with implementing this in Excel 2016? I'm open to any and all ideas!
Thank you in advance for your time reading this.