jmccullough
New Member
Hello All, I have an Excel workbook with 3 worksheets which contain the Data (worksheet1), a Pivot Tabe (worksheet2) and a Column Chart on worksheet3. What i am attempting to do is to color the columns according to month/yr. My data goes back 3 yrs. So for example, any data for Sep08, Sep09 and Sep10 will all be colored Yellow and so on. I have attached my macro to a button and placed it onto my chart. The column colors are working most of the time however if I click on the button to execute the colorchanger macro I receive the 400 Error. I have my macro stored in "VBAProject (Book1) This WorkBook" and I am running windows xp and using Excel 2010 (recently upgraded) but I had the same error using Excel 2007.
Any help would be greatly appreciated. Thank you in advance.
Any help would be greatly appreciated. Thank you in advance.