Error Changing Button Text
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 wrote:
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
|