Hi,
Insert a module, cut and past your macro in it.
Best regards "Pour�trouver�une�solution��ses�probl�mes,�il�faut�s'en�donner�la�peine."

Thanks for your reply but this doesn't help me to run the macro on ANY future sheets. I don't want to copy the module each time, if that's what you are implying. The names of the worksheets will change frequently so I want to be able to click on any worksheet and run the Macro. Thanks again.

Maybe ActiveSheet.Name

There's no need for the .name part, just ActiveSheet works fine in Excel 2007.

One thing I noticed is you may have to have ActiveSheet proceed each method.

As an example, here's a short macro that saves the data from each cell in row H into a word document.
The macro is saved in an empty Excel file and it works for any Excel file loaded (assuming the empty Excel file with the macro is also loaded).

Without ActiveSheet preceeding things like Range("H" & i).Copy, the macro will try to do stuff with the Empty Excel file that has the macro.

Sub saveToWord

    Dim i As Integer
    Dim finalRow as Integer
    Dim appWD As Object
    Dim myString as String
    Dim numberOne as String
    Dim numberTwo as Strng
    Dim myFilename As String

    ' Create a new instance of Word & make it visible
    Set appWD = CreateObject("Word.Application")
    appWD.Visible = True

    'Find the last row with data in the database
    finalRow = ActiveSheet.Range("A9999").End(xlUp).Row
    For i = 2 To finalRow
        myString = ActiveSheet.Range("a" & i).Value

       ' these two cells are both alphanumeric cells; first two characters are always numbers
       numberOne = Left(ActiveSheet.Range("b" & i).Value, 2) 
       numberTwo = Left(ActiveSheet.Range("c" & i).Value, 2) 

       ' Build the unique filename. 
       ' In my Excel file these three elements are sufficient to make the filename unique
       myFilename = myString & " " & numberOne & " " & numberTwo

       ' We want to put the data from cell H into a word doc
       ActiveSheet.Range("H" & i).Copy
    
       ' Tell Word to create a new document
       appWD.Documents.Add
       ' Tell Word to paste the contents of the clipboard into the new document
       appWD.Selection.Paste
       ' Save the new document with the filename and close the word document
       appWD.ActiveDocument.SaveAs filename:= myFilename
       appWD.ActiveDocument.Close
       
    Next i

    ' Close the Word application
    appWD.Quit
End Sub