Why is default font white in new sheets of only one wb?

Micron

Well-known Member
Joined
Jun 3, 2015
Messages
7,185
Office Version
  1. 365
Platform
  1. Windows
I have a wb that I use for testing code to help out here. Somehow, something happened to cause it to make the font white for any new sheet I create in it. If I insert a new sheet in other wb's the font defaults to Auto. If I paste from notepad into the new sheet in the problem wb, the text is not visible. I know the value is there because I can go to cell formatting and reset the white font setting to auto and it appears. I have Googled for a solution and can't find one. I've also looked in options but didn't find any that applied to font colour for new sheets or for pasting. I've also
- searched all code for vbWhite and 16777215 in case that was doing it
- checked that it's not due to an applied theme or style
- checked for code in workbook opening that might be causing it (found nothing)
- even though it does not happen in other workbooks, I checked personal.xlb as well and found no cause there either

Any ideas as to what else I can look for? While I'm at it, is there a way to set the default paste to 'match destination' instead of me having to select that each time?
TIA
 
After an hour of looking I stumbled on the answer on Reddit. Somehow I had changed the font colour in the default style dialog.
 
Upvote 0
Solution

Forum statistics

Threads
1,226,771
Messages
6,192,918
Members
453,766
Latest member
Gskier

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top