default shapes in excel 2007

[already]

Hello

Is it possible to change the default shape formatting in excel 2007 for
using it in another 'session'.

When I add a shape to a sheet the fill is blue an the line (also blue) is 2
pt.

When I change this to the shape I want I can set it as the default shape but
only for the current session. Is it possible to set the format from the
default shapes to the shapes you want for using them any time or is it
possible to create a macro for this?

Thanks in advance

Kind regards

Al

 

[ShaneDevenshire]

Hi,

It seem that setting the default applies to the current workbook, not the
current session. However, maybe you are asking can you set it for all
workbooks?

I suspect you could create a macro which would do this, it would create a
shape in whatever wb you were in and apply to format you want, then issue the
save as default command and finally delete the shape. You should be able to
record these steps.

If this helps, please click the Yes button

 

[already]

Hi Shane

The problem for recording a macro for this is how to select the new shapes
in the first step of the macro

Kind regards

Al