Hi

From an XL97 WB I am trying unsuccessfully to reset the
colors in an Excel5-7 file:

ActiveWorkbook.ResetColors

Error 1004 Method 'ResetColors' of object'_Workbook' failed

If I do same manually it works fine, a recorded a macro
also produces same line as above (but no error).

I think it must be something peculiar to the file I am
trying to reset, I can reset other xl 5-7 files without
any problem. The file has no protection of any kind, at
least none I can identify.

TIA for advice
Regards,
Sandy