Hi,

I've inherited a spreadsheet (Excel 2002) with my golfclub's
membership list. Everytime I insert a new sheet from within this
workbook,the new sheet comes up with a terrible green background with
no gridlines.

If I select the entire new sheet, I can change the background colour
to "Automatic" to get my normal white colour with grew gridlines.

How do I reset this back to the default white background with grew
gridlines? The problem only appears with this particular workbook.

Cheers, Kaye

How do I reset this back to the default white background with grew
gridlines? The problem only appears with this particular workbook.

I am not sure if this will work for you as I do not have a file to
compare it to for testing, but here is an excerpt from the help
files. I think this should help:

Reset workbook and worksheet settings
If you want to keep your Book.xlt or Sheet.xlt files, rename them and
save them in the Templates folder, usually located at:
C:\Documents and Settings\user_name\Application Data\Microsoft
\Templates

Do one or more of the following:
In Microsoft Windows Explorer, remove any template files from the
XLStart folder. The XLStart folder is usually located at:
C:\Program Files\Microsoft Office\Office11\XLStart

If the files aren't in the XLStart folder, look in the folder
specified in the At startup, open all files in box on the General tab
in the Options dialog box (Tools menu).
To restore original settings for workbooks, remove Book.xlt
To restore original settings for worksheets, remove Sheet.xlt

Hope that helped,

Mark

Thanks Mark, but this didn't solve my problem unfortunately.

It appears every sheet I insert into this particular spreadsheet has
the green background.

The problem doesn't exist with other existing or new spreadsheets.

I've tried opening this particular spreadsheet with "Macros Disabled"
but the problem still exists, that is, a green background if I insert
any new worksheets.

Regards,
Kaye

On 11 Feb 2007 04:26:10 -0800, "Mark" wrote:

How do I reset this back to the default white background with grew
gridlines? The problem only appears with this particular workbook.

I am not sure if this will work for you as I do not have a file to
compare it to for testing, but here is an excerpt from the help
files. I think this should help:

Reset workbook and worksheet settings
If you want to keep your Book.xlt or Sheet.xlt files, rename them and
save them in the Templates folder, usually located at:
C:\Documents and Settings\user_name\Application Data\Microsoft
\Templates

Do one or more of the following:
In Microsoft Windows Explorer, remove any template files from the
XLStart folder. The XLStart folder is usually located at:
C:\Program Files\Microsoft Office\Office11\XLStart

If the files aren't in the XLStart folder, look in the folder
specified in the At startup, open all files in box on the General tab
in the Options dialog box (Tools menu).
To restore original settings for workbooks, remove Book.xlt
To restore original settings for worksheets, remove Sheet.xlt

Hope that helped,

Mark