Font Color turned Red on all saved Excel files

%3CLINGO-SUB%20id%3D%22lingo-sub-2839108%22%20slang%3D%22en-US%22%3EFont%20Color%20turned%20Red%20on%20all%20saved%20Excel%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2839108%22%20slang%3D%22en-US%22%3E%3CP%3ENot%20sure%20why%20or%20how%20this%20is%20happening.%20When%20I%20open%20a%20saved%20excel%20file%20the%20font%20which%20was%20saved%20as%20black%20is%20now%20red.%20How%20do%20I%20fix%20this%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2839108%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Not sure why or how this is happening. When I open a saved excel file the font which was saved as black is now red. How do I fix this please?

2 Replies

Without seeing your setup, it sounds as if you have some code running ON SAVE or ON OPEN.

If it's happening just for you, I suggest finding the PERSONAL.XLSB in the XLSTART folder, and removing it by copying it out of there, perhaps to your documents folder for future inspection. For more info, check here: https://support.microsoft.com/en-us/office/copy-your-macros-to-a-personal-macro-workbook-aa439b90-f8...

 

If it's happening across an organization, well...there's a gremlin running around somewhere.

@edawcj Thank you for your suggestion on fixing my issue. You are amazing for offering your help. Unfortunately, I will not be able to try it out as the issue resolved itself after a computer reboot. I will refer back to this if it happens again. have a wonderful day!!!