Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want a macro that change an object font style from bold to regular and regular to bold
hi,
You can write similar code in macro to acheive the result.
set chart = ActiveDocument.GetSheetObject("CH01")
set p = chart.GetProperties
p.ChartProperties.BlockCaptionFont.Bold = true
chart.SetProperties p
ChartProperties not supporting
HI,
Check if the object id is correct in your case. i.e CH01
Actually I want to change the caption font of a button
HI,
Try this code.
set obj = ActiveDocument.getsheetobject("BU01")
fnt = obj.GetFrameDef.Font
fnt.PointSize1000 = fnt.PointSize1000 + 1000
obj.SetFont fnt
But I dont want to set the font size
I want to make the font bold
Can you provide the syntaz for changing the font color?
Also, do you know how to use an option other than "Set by Style" on the Font tab of objecet properties. I am being forced to use it and cannot customized my fonts by object.
Thanks!
This macro works ror me;)
sub Bold
set obj = ActiveDocument.GetSheetObject("BU01")
fnt = obj.GetFrameDef.Font
fnt.Bold = true
obj.SetFont fnt
end sub