1Attribute VB_Name = "SetTextBoxFont"
2'/*************************************************************************
3' *
4' DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
5'
6' Copyright 2000, 2010 Oracle and/or its affiliates.
7'
8' OpenOffice.org - a multi-platform office productivity suite
9'
10' This file is part of OpenOffice.org.
11'
12' OpenOffice.org is free software: you can redistribute it and/or modify
13' it under the terms of the GNU Lesser General Public License version 3
14' only, as published by the Free Software Foundation.
15'
16' OpenOffice.org is distributed in the hope that it will be useful,
17' but WITHOUT ANY WARRANTY; without even the implied warranty of
18' MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
19' GNU Lesser General Public License version 3 for more details
20' (a copy is included in the LICENSE file that accompanied this code).
21'
22' You should have received a copy of the GNU Lesser General Public License
23' version 3 along with OpenOffice.org.  If not, see
24' <http://www.openoffice.org/license.html>
25' for a copy of the LGPLv3 License.
26'
27' ************************************************************************/
28
29Option Explicit
30
31' We change the font used for text box shapes here for the japanese
32' version, because office 2000 sometimes displays squares instead of
33' chars
34Public Sub SetTextBoxFont()
35    Dim aSheet As Worksheet
36    Dim myShape As Shape
37    Set aSheet = Sheets(1)
38
39    For Each myShape In aSheet.Shapes
40        If myShape.Type = msoTextBox Then
41            myShape.Select
42            With Selection.Characters.Font
43                .Name = "MS PGothic"
44                .Size = 10
45            End With
46        End If
47    Next myShape
48    Range("A1").Select
49End Sub
50
51