Button Name change

  • Thread starter Thread starter rhani111
  • Start date Start date
R

rhani111

Hi All,

Hopefully there is an easy way to do this.....

I want the text on my macro button to change if the *-Sheet-* name
changes. Is this possible?

At the moment this is my vba code
ActiveSheet.Shapes("Button 415").Select
Selection.Characters.Text = "Shot 2"
With Selection.Characters(Start:=1, Length:=7).Font
Name = "Arial"
FontStyle = "Bold"
Size = 10
Strikethrough = False
Superscript = False
Subscript = False
OutlineFont = False
Shadow = False
Underline = xlUnderlineStyleNone
ColorIndex = 1

Thanx heaps in advance
San
 
Back
Top