style

Hi everyone, I am using excel 2007 and need to use pie charts for a presentation. My boss insists on using one of the pre-set styles ("Chart Style 11", a lot of shades of blue). However, I need to manually create a legend in powerpoint using text boxes, and I'd like to fill in the text boxes...

Hello I'm a little bit out of my depth here and I'm looking for some help with Word VBA. I have a paragraph mark for which I need to change the style from "Heading 3" to "Normal". The text flows as follows: Normal text in normal style (CR) (PM) New Heading in Heading 3 style (CR) where: (CR)...

I have a workbook where I am missing the default pre-defined cell styles. For example the “Good, Bad” (Green/Red) cell formatting. The listings you would normally see when you click on “Styles” on the Excel Ribbon. Default Cell Styles! <TBODY> Good, Bad and Neutral</SPAN> Normal</SPAN>...

the code is to create chart and but name, title, range, style and type for chart the code run well except type and style any idea Charts.Add With ActiveChart .HasTitle = True .ChartTitle.Text = Application.InputBox("Please enter chart Title", "Chart Title", "As of " &...

Hi All Here's a non-codey one for you. XP/2007 I am about to roll out a group of 5 workbooks and am trying to think of a consistent and eye-catching theme to impress my client. My standard is white background titles with navy background and white lettering Heading1, Heading 2, Good/Bad...

I have created a table style in my Persoanl workbook but it does not appear in the gallery on other workbooks. Is there a way of creating a style that will always be available? I am using Excel 2010 on Win 7

Hello, is there a macro that can select all cells with a certain style and then clear the values. The idea is that a big document has cells that are formatted as "entry-fields" and others that are not. I want to be able to select all of them with a macro (they are everywhere) and clear them of...

I would like to create a new pivot style or make it so that the pivot maintains the following style: The actual file has as ton of data.. and I would like to create a style that at least is similar to that. The built in styles do not make the cut. I have been trying to modify one of the...

Hi folks, A fairly complex excel file I have has decided to play tricks and has set the default style to currency. Now I know the way to reset this is to select the 'normal' style in the list, and change this back to 'general', however I don't have a 'normal' style. All the default ones have...

Hi I have a userform that contains a textbox within the code when a criteria is met it is disabled with a text message "select file type" when it is displayed the text is grey with a white shadow which makes it hard to read how can you change the style of text when it is in a disabled state. thanks

Hi I've written macros to create, format, and select a style (background colours, font colours etc.). Then I wrote a macro to copy the pivot table values and format (number formatting) across to a new worksheet. However I'm struggling to copy across the styles (colour backgrounds) across? I...

I have these 4 very simple style formatting macros, but I can't quite get them to work right every time. The issue is the information between the quotation marks. Here is the code: Sub Number() ' ' Number Macro ' Number format with no decimals ' ' Selection.NumberFormat = "#,###" End Sub...

In my y-axis there are values above and below the origin. Is there a way i can make the origin line thicker so that it stands out from the other lines on the y-axis? I hope i've managed to explain. Thanks in advance.