View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andym Andym is offline
external usenet poster
 
Posts: 35
Default Button Text Problem

I Have recently installed Excel 2007 and some code that worked on previous
versions now does not work.

I am trying to create a button with 3 lines of text using the following code:

ActiveSheet.Buttons.Add(23.25, 17.25, 209.25, 87).Select
Selection.Characters.Text = "CALCULATE:" & Chr(10) & "Calcultation Step
1" & Chr(10) & "Calculation Step 2"


In previous versions of Excel this code would give me a button with 3
lines:

CALCULATE
Calculation Step 1
Calculation Step 2


In 2007 version all i get is an error message saying
"Run-time error '1004'

Can anyone explain why or suggest a way to create a button that will start a
new macro?


Thanks