Assigning name to button
Grant,
The problem is being caused the name "Button 1"
Insert a line after the first line and add this:
Selection.Name = "AB"
Change the fourth (3rd in the old macro) line to this:
ActiveSheet.Shapes("AB").Select
It does now work on my machine.
Regards
Jamal
-----Original Message-----
Hi
I have recorded a macro that creates a button, assigns a
macro and positions
the button. In my spreadsheet application it is often
necessary to destroy
objects and if I run the macro again to recreate the
button, I get a
Run_time error saying that the item with the specified
name wasn't found. I
understand why it is happening, but don't know what the
workaround can be,
bearing in mind that I will need to frequently destroy
the button and
recreate it. Can one force the button to be created with
a specific name?
Can anyone help? My code is below;
Sub BuildButton()
ActiveSheet.Buttons.Add(4.5, 3, 72, 72).Select
Selection.OnAction = "Connect2Servers"
ActiveSheet.Shapes("Button 1").Select
Selection.Characters.Text = "Connect to Servers"
With Selection.Characters(Start:=1, Length:=18).Font
.Name = "Arial"
.FontStyle = "Regular"
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
End With
Selection.ShapeRange.ScaleWidth 2.19, msoFalse,
msoScaleFromTopLeft
Selection.ShapeRange.IncrementTop -0.75
Selection.ShapeRange.IncrementTop -0.75
Selection.ShapeRange.IncrementTop -0.75
Selection.ShapeRange.IncrementTop -0.75
Selection.ShapeRange.IncrementLeft -0.75
Selection.ShapeRange.IncrementLeft -0.75
Selection.ShapeRange.IncrementLeft -0.75
Selection.ShapeRange.IncrementLeft -0.75
Selection.ShapeRange.IncrementLeft -0.75
Selection.ShapeRange.IncrementLeft -0.75
Selection.ShapeRange.IncrementLeft -0.75
Selection.ShapeRange.IncrementTop -0.75
End Sub
Many Thanks - Grant
.
|