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
- 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