Simple Excel Question: Bold / Not Bold in one cell

[bradgar]

Hi all,

I have some text that are Bold / Not Bold in one cell. I change the color of the cell and it looks fine. I save, close, re-open and the bold part has changed color. I have even tried to hard program so that it changes to my desired color at the end of my open procedure in VBA, but this doesn't even work.

Any ideas how to fix this?

EX: SOMETHING. The SOM stays the correct color on open, the ETHING changes color on open (All in one cell).

 

[ZAX]

Hi Bradgar,

It's very simple,all you have to do is to press Alt + F9 to open VBA Then Enter The Following Code in the Workbook and
Remember to type the cell address between the quotes.

Private Sub Workbook_Open()
Range("Type Cell Address Here").font.bold = True
End Sub

ZAX

 

[bradgar]

Thanks Zax, but please re-read my post.

I already have the VBA I need. The font is part bold, part not bold. The bold font's color changes on workbook open, which I do not want.

 

[ZAX]

Thanks Zax, but please re-read my post.

I already have the VBA I need. The font is part bold, part not bold. The bold font's color changes on workbook open, which I do not want.

Then can you share the code with us so we can know what the code is doing? and sorry for the very very late reply, I've been away for a while and now I'm back :D