Thank you all for the help.
I don't know what is wrong with this version of XL, but DM unseens tip
will not work either!?!
This is how a textbox is made (recorded macro):
Sub add_textbox()
'
' add_textbox Macro
' Macro recorded 19/07/2005 by Ask Greiffenberg
'
'
Application.CommandBars("Drawing").Visible = True
ActiveSheet.Shapes.AddTextbox(msoTextOrientationHo rizontal, 226#,
84#, _
214#, 323#).Select
Selection.Characters.text = ""
With Selection.Font
..Name = "Verdana"
..FontStyle = "Regular"
..Size = 10
..Strikethrough = False
..Superscript = False
..Subscript = False
..OutlineFont = False
..Shadow = False
..Underline = xlUnderlineStyleNone
..ColorIndex = xlAutomatic
End With
End Sub
I know it's possible to make boxes another way (don't know how),
perhaps that would help?
Greiffenberg
--
Greiffenberg
------------------------------------------------------------------------
Greiffenberg's Profile:
http://www.excelforum.com/member.php...o&userid=25311
View this thread:
http://www.excelforum.com/showthread...hreadid=388003