Error Changing Button Text

[David]

My script is stopping on this line when run on Excel 2007:
Selection.Characters.Text = "Click to Create Weekly File" & Chr(10) & "&
Change Date"
It works fine in Excel 2003. What change would I need to make so that it
runs in both 2007 and 2003?
THanks!

 

[Dave Peterson]

This has come up before.

It appears that the max number of characters that you can add to the caption is
33. (I don't know a way around that limitation (bug????).)

So you could change your caption or maybe stick a button on different
(hidden???) sheet and just copy it from there (already formatted, too).

 

[David]

Thanks much Dave for the options and quick response!