theme

  1. R

    VBA to theme my charts?

    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 =...
  2. S

    Custom Theme

    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...
  3. M

    Excel 2016 - VBA - Troubleshooting Macro that Should Work But Isn't Working?

    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...
  4. D

    VBA? Change automatic colors

    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...
  5. G

    Data Analysis - Related Open Ended Questions with a yes/no response

    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...
  6. J

    Theme issue between PC & Mac version of excel

    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...
  7. bencar

    Explain Why this Pivot Table is Layed Out this Way

    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...
  8. J

    Small Theme Issue Between PC & Mac

    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...
  9. V

    Save Theme Permission Denied

    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?
  10. J

    Making Custom Colours appear on the Colour Palette on Startup

    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...
  11. bencar

    Prevent Custom Theme from Affecting Spreadsheets?

    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?
  12. C

    Force stop automatic color variance in charts

    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...
  13. Chris Macro

    VBA to get ThemeColor from a Bar Chart

    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)...
  14. djl0525

    Need code to edit text

    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...
  15. V

    VBA - VBE Theme Color Editor

    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...
  16. C

    Apply Excel theme or default shape upon opening any Excel workbook

    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...
  17. 1

    Copying Word Theme to another document using Excel VBA

    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...
  18. A

    Standard Color Set Excel

    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...
  19. C

    Excel Themes

    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...
  20. G

    Excel macro Custom Message box theme

    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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top