Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell pattern-style and color in Excel 2007
Im looking for a Macro or an Add-on¦
Ive just been upgraded to Excel 2007. In the old Excel version, one could add a drop-down box to the toolbar for formatting the pattern color and pattern styles of a cell. It looked and functioned a lot like the "fill color" button. Excel has left off its counterpart in the 2007 version -- neither on the ribbon, or in the list of available buttons for the Quick-Access Toolbar. I used this button CONSTANTLY! In the new version, I have to open the font dialogue box, click to the fill page, click on the pattern color box, then on the pattern style box seven clicks in all every time I want to change a new cell area! In the old version of Excel, it took one click on the toolbar to paste in the color and pattern that Id used last, or three clicks to choose a new scheme. Is there an add-on, or a macro that I can use to recreate the button as it existed in the old version of Excel? Id love to be able to add it to the font area of the ribbon but adding it to the Quick-Access Toolbar would do just as well. Many thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Chart - determining the color of a chart style | Charts and Charting in Excel | |||
Cell Style Button in Excel 2007 | Excel Discussion (Misc queries) | |||
Cell pattern/color | Excel Discussion (Misc queries) | |||
Cell pattern-style and color in Excel 2007 | Excel Programming | |||
Cell color pattern styles in Excel 2007 | Excel Discussion (Misc queries) |