Hi Jan,

Sorry, I was referring to Version 2003. This may not relevant to 2007.

Challa Prabhu

"Jan" wrote:

Hi

Thanks very much for your answer but I was not clear in my original post I'm
on version 2007 and you cannot customize the toolbar in this way anymore.
You can customize the quick access toolbar but I cannot find the icon for
patterns to put on the quick access toolbar.


"challa prabhu" wrote:

Hi,

To view the Customize dialog box, do one of the following:
€¢ On the View menu, point to Toolbars and then click Customize.
€¢ On the Tools menu, click Customize

1. Click the Commands Tab.
2. In the Categories list, click Insert.
3. In the Commands list, click AutoShapes.
4. Drag the AutoShapes button and place it in the toolbars displayed below
the
applications menu.
5. Click the AutoShapes button.
The AutoShapes Toolbar appears.
6. Click Basic Shapes button in the AutoShapes Toolbar.
7. Click on Rounded Rectangle
8. Click and drag to create a shape in the Excel Sheet.
9. Right-click on the selected rounded rectangle and click Format AutoShapes.
The Format AutoShapes dialog box appears.
10. Click Color and Lines Tab.
11. Under Fill, click the Color list.
12. Click Fill Effects.
13. Click the Pattern Tab. Choose by clicking the any pattern.
14. Click OK. Returns to AutoShapes dialog box.
15. Click OK.

Challa Prabhu

"Jan" wrote:

In the 2003 version of excel you could add the patterns as a button like the
colour button and text colour button. I cannot find this function in the
commands to enable me to add it to the quick access toolbar. Has anyone else
found it and if so could they let me know where it is?
Thanks