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