Error Changing Button Text

  • Thread starter Thread starter David
  • Start date Start date
D

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!
 
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).
 
Back
Top