Text Box format from 2003 to 2007

**braydon16** · 03-04-2010, 01:35 PM

I created a worksheet with a textbox as a header in 2003 with the following font characteristics; Arial, size 14, bold, white. When I open the file in 2007, it changes to Calibri (07's default font), 11, unbolded, black.

Is there any way to prevent this?

Thanks in advance for the assistance.

**TYork** · 03-04-2010, 01:56 PM

Did you try changing your default font? You can do this by going to the windows button -> Excel Options at the bottom.

**braydon16** · 03-04-2010, 02:10 PM

I haven't. Won't that effect the entire workbook?

**TYork** · 03-04-2010, 02:19 PM

Yes it will.

**braydon16** · 03-04-2010, 04:57 PM

This doesn't solve the issue. The issue is, if it's created in 2003, 2007 does not pick up the same formatting. It changes it to it's default. Your solution works well for me, but this is a tool I am creating in 03 that others may be opening in 07. I should have been more clear.