How do I change font size of the name on my command button?
How do I change font size of the name on my command button?
You can set this under the font option on the properties window (F4 in the VBA editor)
thanks for the help
"mrice" wrote:
>
> You can set this under the font option on the properties window (F4 in
> the VBA editor)
>
>
> --
> mrice
>
> Research Scientist with many years of spreadsheet development experience
> ------------------------------------------------------------------------
> mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
> View this thread: http://www.excelforum.com/showthread...hreadid=537313
>
>
This procedure restores the buttons in the active worksheet
Sub ButtonRestore()
Dim shp As Shape
For Each shp In ActiveWorkbook.ActiveSheet.Shapes
If shp.Type = 12 Then
shp.Height = shp.Height + 1
shp.Height = shp.Height - 1
End If
Next shp
End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks