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%3CLINGO-SUB%20id%3D%22lingo-sub-2839760%22%20slang%3D%22en-US%22%3ERE%3A%20Font%20Color%20turned%20Red%20on%20all%20saved%20Excel%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2839760%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1181078%22%20target%3D%22_blank%22%3E%40edawcj%3C%2FA%3E%26nbsp%3BThank%20you%20for%20your%20suggestion%20on%20fixing%20my%20issue.%20You%20are%20amazing%20for%20offering%20your%20help.%20Unfortunately%2C%20I%20will%20not%20be%20able%20to%20try%20it%20out%20as%20the%20issue%20resolved%20itself%20after%20a%20computer%20reboot.%20I%20will%20refer%20back%20to%20this%20if%20it%20happens%20again.%20have%20a%20wonderful%20day!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2839745%22%20slang%3D%22en-US%22%3ERe%3A%20Font%20Color%20turned%20Red%20on%20all%20saved%20Excel%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2839745%22%20slang%3D%22en-US%22%3E%3CP%3EWithout%20seeing%20your%20setup%2C%20it%20sounds%20as%20if%20you%20have%20some%20code%20running%20ON%20SAVE%20or%20ON%20OPEN.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20it's%20happening%20just%20for%20you%2C%20I%20suggest%20finding%20the%20PERSONAL.XLSB%20in%20the%20XLSTART%20folder%2C%20and%20removing%20it%20by%20copying%20it%20out%20of%20there%2C%20perhaps%20to%20your%20documents%20folder%20for%20future%20inspection.%20For%20more%20info%2C%20check%20here%3A%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcopy-your-macros-to-a-personal-macro-workbook-aa439b90-f836-4381-97f0-6e4c3f5ee566%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcopy-your-macros-to-a-personal-macro-workbook-aa439b90-f836-4381-97f0-6e4c3f5ee566%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20it's%20happening%20across%20an%20organization%2C%20well...there's%20a%20gremlin%20running%20around%20somewhere.%3C%2FP%3E%3C%2FLINGO-BODY%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!!!