theme

I'm wanting to condense my code to make it a bit faster but I'm not too familiar with the chart styling. Heres what I have: Sub Make_Pretty() Sheets("Shot Data").Select Range("ShotData[#Headers]").Select With Selection.Interior .Pattern = xlSolid .PatternColorIndex =...

Hi, I am have a Line and stacked column chart Visual with formatting. (Show Data labels for CUSTOMIZE SERIES etc). I need a JSON Theme file for using with other similar visuals. Sample file is available in the link https://drive.google.com/open?id=1UmilRTUm_LGfv-tRoIXyyVpv3mLTOPtV Request...

I have an Excel 2016 VBA macro that changes the "Office Theme" under: File>Account>Office Theme; to the next theme. This macro should work as when I try and perform the macro's sequence of actions manually the sequence of actions is successful in changing the "Office Theme" - would anyone might...

Hello Everybody. I work long hours on my laptop and I'm trying to customize a little the appearance of my PC. I'd like a DARK theme, but unfortunately, Windows 7 doesn't think I deserve it: I managed to get a dark theme (without aero) but this changes the "default colors" and excel became...

Hi, I've searched multiple different queries with google about how to accomplish this with excel but have had no luck. I have a question on a survey which reads: Q1. What advice was given during call? I plan on grouping the responses into themes/categories which I have found out how to...

This seems like a really simple problem but I keep running into this issue over and over again. I'm a student and I have assignments that ask for specific themes/layouts in Excel 2016. I have Excel on both my PC and my Macbook, and most of the time the theme that was requested will be available...

Hi guys, Trying to figure out why this pivot table is layed out the way it is. Here are my 4 questions. Below that is the exercise and its info. 1. Why is 'design' in the column area? 2. Why are 'amusement park' and 'roller coaster' in the row area? 3. Why is 'type' in the filter section? 4...

This seems like a really simple problem but I keep running into this issue over and over again. I'm a student and I have assignments that ask for specific themes/layouts in Excel 2016. I have Excel on both my PC and my Macbook, and most of the time the theme that was requested will be available...

Hello, Does anyone have any idea why this line of VBA: ThisWorkbook.Theme.ThemeColorScheme.Save ("C:\myThemeColorScheme.xml") works fine for me, the person that created the workbook, theme and macro but throws up a 'Permission Denied' error for anyone else?

Hi: This particular issue relates to Office 2013, but I believe it also is current in 2016. We have common MS Office theme thmx files populating custom colors, which works as expected on PPT and Word, ie the formatting colour palettes contain three sections, Theme Colors, Custom Colors and...

Hi. i got a win 10 custom theme installed. But it affects the background color of my spreadsheets. Is there a vba that can black any themes from affecting them?

Hi, We are trying to create a color theme to restrict the colors Excel to just our branded colors. I know how to change the first 6 colors in a series, but I don't know how to get Excel to stop auto formatting the rest of the colors and just force it to use our branded colors instead. I was...

I am trying to figure out how to retrieve the theme color property from a bar chart. If I select a Bar Chart that has a fill color associated with a theme color and execute the following code: Selection.Format.Fill.ForeColor.ObjectThemeColor it returns a value of 0 (aka msoNotThemeColor)...

I need a macro to: - Remove the numbers for number bulleted items - Remove the letters for alpha bulleted items - Insert two line breaks after each sentence - Replace → with [space]>[space] - Remove [space]▼ (replace with nothing) There can be as many as 20 bullets; they can go beyond E and 7...

Hello, Has anyone used this and managed to get it working: GitHub - gallaux/VBEThemeColorEditor: The VBA / VB editor (or VBE) is limited in the 16 colors it can use to render code text. This application replaces the default colors with custom palettes that can be saved and loaded. It is...

Our executives get excel documents from many sources. They want to change their default shape background from blue to blank. I have read how to: 1. Set the default shape, but unfortunately its only for the current document(many sources of files) 2. Set new templates - only work if they...

Hi, Is there a way to use VBA to save the current Word Document's Theme as a file in a location that I choose? Essentially VBA code to do the same as clicking on this: Background: I'm working on an Excel macro that uses VBA coding to take a template document, make a copy of it and replace...

Ok, hopefully this can actually be done. When I’m in excel and click the ‘Fill’ or ‘Text Color’ drop down, I am presented with ‘Theme Colors’ which displays the matrix of 10 colors and then 5 rows of corresponding hues, and ‘Standard Colors’. In my line of work, the consistency with colors used...

I've created a company branded theme that I want to use in a power view, however from the power view I can only access a list of themes created by Microsoft so I was hoping that someone might know where they are in my file system so I can either add my theme there or edit one of Microsofts...

Hi, I need to change the msgbox,inputbox theme color.. for example : i have 6 msg box i want them to be in white and red color.. Could you please help out.. Thanks in advance