Font color dropdown crashes excel when macros enabled

%3CLINGO-SUB%20id%3D%22lingo-sub-1303691%22%20slang%3D%22en-US%22%3EFont%20color%20dropdown%20crashes%20excel%20when%20macros%20enabled%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1303691%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20Office%20365%20home%20subscription.%26nbsp%3B%20Windows%2010.%26nbsp%3B%20Lately%2C%20whenever%20I%20attempt%20to%20use%20the%20Font%20drop%20down%20for%20Text%20or%20Fill%20colors%2C%20%22Excel%20has%20stopped%20working%22%20pops%20up%20and%20the%20workbook%20closes.%26nbsp%3B%20This%20only%20occurs%20in%20workbooks%20that%20have%20enabled%20macros.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20unchecked%20COM%20addins%2C%20to%20no%20avail.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20attempted%20to%20solve%20the%20issue%20by%3A%26nbsp%3B%201.%20Disabling%20macros%26nbsp%3B%202.%20Saving%20the%20workbook%26nbsp%3B%203.%20Closing%20the%20workbook%26nbsp%3B%204.%20Reopening%20the%20workbook...%20only%20to%20find%20ALL%20my%20macros%20(dozens)%20were%20GONE.%26nbsp%3B%20I%20do%20have%20back-ups.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EChat%20session%20and%20remote%20access%20with%20support%20team%20got%20me%20nowhere.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20new%20here%20but%20would%20greatly%20appreciate%20any%20assistance%20offered.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1303691%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I have an Office 365 home subscription.  Windows 10.  Lately, whenever I attempt to use the Font drop down for Text or Fill colors, "Excel has stopped working" pops up and the workbook closes.  This only occurs in workbooks that have enabled macros.  

 

I have unchecked COM addins, to no avail.  

 

I attempted to solve the issue by:  1. Disabling macros  2. Saving the workbook  3. Closing the workbook  4. Reopening the workbook... only to find ALL my macros (dozens) were GONE.  I do have back-ups.

 

Chat session and remote access with support team got me nowhere.

 

I'm new here but would greatly appreciate any assistance offered.

0 Replies