[GhoulGreen]

Hiya

I'm working on a large workbook. Alot of the worksheets have a button with a macro behind them that makes a XML file using some of the data on the sheet.

I'm making a button with a macro that clicks all the other buttons. The buttons on the other pages are just normal buttons(form controls), and they all have the same name "To XML".

So far I've written this code but I can't get it to work. It does go though all worksheets and get the shapes, but I fail to select the button and click it. Does anybody have an idea how to make this work?

//This code is not exactly what i wrote, but it had the same structure. I am at home right now and can't access my work computer..

Sub clickAllXmlButtons() 
    Dim ws As Worksheet 
    For Each ws In ActiveWorkbook.Worksheets 
         Dim sh As Shape
         For Each sh in ws.Shapes
              If sh.Text = "To XML" Then
                   sh.Select
                   sendKeys(" ")
              End If
         Next sh    
    Next ws 
End Sub 

[GhoulGreen]

Ok the problem is solved so I am posting the solution here.
It is a lot easier to call the macro behind the button within the context of the worksheet.
So I activate the worksheet and if it conains the control which I want, then I execute the function.

Sub ClickAllCreateButtons()
    Dim ws As Worksheet
    For Each ws In ActiveWorkbook.Worksheets
    ws.Activate
        Dim sh As Shape
        For Each sh In ws.Shapes
            If (sh.Type = msoFormControl) Then
                If (sh.FormControlType = xlButtonControl) Then
                    If (sh.TextFrame.Characters.Text = "To XML") Then
                        Call toXML
                    End If
                End If
            End If
        Next sh
    Next ws
End Sub

[maj3091]

Well done on solving the issue yourself and thanks for posting the solution for the benefit of others.

[BobRodes]

As a further point, you can directly call your event handler too. If your button is named command1, then your event handler is Command1_Click(). Command1_Click will call your event handler just as if the user had clicked the button.