Or, if you still have a file with shapes with patterns, copy and paste the patterns (CTRL+SHIFT+C, CTRL+SHIFT+V)
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
| Yes, you're right; seems like it can't be done.
|
| You can still use VBA to do it, like
|
| Selection.ShapeRange.Fill.Patterned msoPatternNarrowHorizontal
|
| The pattern names can be found in VBA help
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
|| Thanks Nick
||
|| When I click on to the little arrow I get a "Format cell" diallogue box but
|| no option to switch to "old" options. It is shapes that I want the old fill
|| options for such as circles, rectangles ets - and not cells.
||
|| Regards
||
|| Andrew Dakers
||
|| "Niek Otten" wrote:
||
|| > On the Home tab, in the Font box, click the little arrow in the right bottom corner. There you will find the "old" options
|| >
|| > --
|| > Kind regards,
|| >
|| > Niek Otten
|| > Microsoft MVP - Excel
|| >
|| > |I liked the fill options we had in Excel 2003. They do not appear to be
|| > | available in Excel 2007 - which only has the picture texture fill options. I
|| > | want the standard cross hatching etc fill options. How can I get these in
|| > | Excel 2007?
|| >
|| >
|| >
|
|