New Sheet Manuualy Add in Excel Format Accounting

[rr1050]

Dear All,

I am really facing one issue which do not found answer on web.

I have workbook, yes workbook contains some VBA codes. But I checked they are not affecting to create my issue. My issue is when I create sheet, (just new sheet) by manually, format goes "Accounting". How, I really do not understand?
About macro would like to tell you, I was using earlier .clear option which was creating that issue; but now I changed to .clearcontents.

But still facing problem while adding sheet; it automatically take "accounting" instead of "General" format.

Pls revert back with your any questions if any or god solutions.

Reg, RL

[karedog]

Hi,

Possibly your Normal Style has been altered.

Look for the explanation here :
link

[newdoverman]

This may help:

http://support2.microsoft.com/kb/291321

[rr1050]

Thanks a lot (to both)

Save life.... It is very hell every time manually change to general.
Thanks once again for time.