2002: Unable to delete Normal_xyz style inherited from workbook(xy

[Guest]

I am using EXCEL 2002.

a)
When copying a sheet from workbook(A) to workbook(B),
sometimes style Normal_A
appears in workbook(B).
This "sometimes" seems to be connected to
new or changed styles in workbook(A).
Is there a way to prevent the style Normal_A to appear.

b)
Sometimes it is possible
and sometimes it is *not* possible to delete this
style Normal_A in workbook(B).
I have nor found an explanation for this.
Is there a way to delete the style Normal_A,
if Format / Style / Delete does not work?

The problem is minor,
but annoying (after many transfers of sheets).

Martti Pekkanen

 

[Guest]

a)
When copying a sheet from workbook(A) to workbook(B),
sometimes style Normal_A
appears in workbook(B).
This "sometimes" seems to be connected to
new or changed styles in workbook(A).

It seems that *always* when the styles "Normal"
are different in the two workbooks, this happens.
But not otherwise.

b)
Sometimes it is possible
and sometimes it is *not* possible to delete this
style Normal_A in workbook(B).

It seems that
when the style Normal_A
equals the EXCEL default style "Normal",
the style Normal_A can be deleted.
But not otherwise.

I hope this is correct and helps someone.

Thanks to Dave Peterson,
who on the 10/6/2005 in
Re: Is it possible to change the default number format in Excel?
gave an invaluable hint for the solution.


Martti Pekkanen