right click menu poits to macro

[TurboDieselOne]

Hi I have a macro assigned to an item in the right click menu
this works ok

but the following makes no difference

 With Selection
        .Value = "UNABLE TO WORK"
    
        .Name = "Arial"
        .FontStyle = "Bold"
        .Size = 12
        .Value ="VACATION"
        .Strikethrough = False
        .Superscript = False
        .Subscript = False
        .OutlineFont = False
        .Shadow = False
        .Underline = xlUnderlineStyleNone
        .ColorIndex = xlAutomatic
        .HorizontalAlignment = xlCenter
        .VerticalAlignment = xlCenter
        .WrapText = True
        .Orientation = 0
        .AddIndent = False
        .IndentLevel = 0
        .ShrinkToFit = False
        .ReadingOrder = xlContext
        .MergeCells = False
    End With [code]
 
The font does not change size or to bold
 
Any ideas greatfully recieved.

 

[Andrew Poulsom]

To set the font to bold:

Selection.Font.Bold = True

 

[TurboDieselOne]

Great Thanks