Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

All cell backgrounds gone grey?

Status
Not open for further replies.

asrisk

MIS
Nov 27, 2003
105
GB
OK, this is an odd one.

I have a workbook in which all of the cells which have no background color (i.e. "No Color") have turned a grey colour (very similar to the colour of the sheet tabs at the bottom) instead of the usual white. New worksheets I create in this workbook have the same colour.

Other existing workbooks are not affected, and neither are new workbooks.

At the time it happened, I was having a violent disagreement with Excel about why I could not run my macros, which were not (apparently) digitally signed. (Oh yes they were). I don't see how this is related though.

Version is Excel 2003 on WinXP Pro (SP1). No conditional formats or styles are applied, the workbook is not protected or shared. Does anyone have any suggestions how I can restore the workbook's pristine whiteness?

Thanks,
Andy.

-------
I am not responsible for any "Sponsored Links" which may appear in my messages.
 
Are you in Page Break Preview with no Print areas set?

View / Normal

Regards
Ken............

----------------------------------------------------------------------------
[peace]It's easier to beg forgiveness than ask permission[2thumbsup]

----------------------------------------------------------------------------
 
Thanks but no, I was in normal view. However, the problem mysteriously resolved itself when I deleted an empty worksheet - all the other worksheets returned to white.

I still have no idea why, but hey! :)

-------
I am not responsible for any "Sponsored Links" which may appear in my messages.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top