Thread
:
Help Excel 2003 code failing in 2007
View Single Post
#
3
Posted to microsoft.public.excel.programming
Bob C
external usenet poster
Posts: 23
Help Excel 2003 code failing in 2007
Hi Nigel
It stopped on the same line with the following error message;
'Run Time Error '1004'
'Unable to set text property of the characters class'
Thank you
Bob C
It cost''s little to carry knowledge with you.
"Nigel" wrote:
It appears that the Chr(10) is the issue here, try using
Selection.Characters.Text = "Click to Run" & vbCrLf & _
"all macro's automatically."
--
Regards,
Nigel
"Bob C" wrote in message
...
The code below ran in Windows Excel 2003 but stops in 2007 at the line
starting with;
Selection.Characters.Text = "Click to Run" & Chr(10) & "all macro's
automatically."
Could anyone point me as to why?
I have recorded the operation in 2007 and the line records the same as
2003.
Dim dWidth As Double
Dim dHeight As Double
Dim dTop As Double
Dim dLeft As Double
[B2].Activate
With ActiveCell
dTop = .Top
dLeft = .Left
dHeight = .Height
dWidth = .Width
End With
ActiveSheet.Buttons.Add(dLeft, dTop, dWidth, dHeight).Select
Selection.OnAction = "Bttn1_RunAll"
Selection.Placement = xlFreeFloating
Selection.Width = 236.5
Selection.Height = 50.5
Selection.ShapeRange.IncrementTop 0.75
Selection.Characters.Text = "Click to Run" & Chr(10) & "all macro's
automatically."
With Selection.Characters(Start:=1, Length:=39).Font
.Name = "Arial"
.FontStyle = "Bold Italic"
.Size = 12
.ColorIndex = 13
End With
With Selection.Characters(Start:=1, Length:=12)
.Font.Size = 24
End With
--
Thank you
Aussie Bob C
It cost''s little to carry knowledge with you.
Reply With Quote
Bob C
View Public Profile
Find all posts by Bob C