Mapping?

[jimmywanna]

Hello my peers,
I received some help yesterday for a macro which i am intending to use to save me an awful amount of time.

scenario:
I have a sheet which i wish to paste into about 120 workbooks.
The sheet will be the new sheet 1.
I want to create a button on the 120 workbooks that when pressed runs a macro to make some changes to the it's presentation.
After that i need the macro to look at the other workbook (which will be open) copy the sheet and move it to the front of the workbook which has had amenments.
I have tried myself but the macro records the name of the workbook. All 120 have very different names.
So far the coding (post changes) looks like this:

Sub Button1_Click()
'
' Button1_Click Macro
' Macro recorded 02/11/2005 by GibsonJa
'

Windows("Book1").Activate
Sheets("Sheet1").Select

Dim wb As Workbook
Set wb = ThisWorkbook
Sheets("Mapping").Copy Before:=wb.Sheets(1)

End Sub

it works right to the point of Sheets("Mapping").Copy.........

I am unaware of the term "mapping" and i think this is the problem, any help would be really great as this could save me hours.

thanks again

jim

 

[jimbojones]

Have you renamed any of your worksheets. When the macro was recorded you had a worksheet called mapping (which may still be there but just hidden). The "Mapping" referes to the name of the sheet and the script moves this sheet to become the first sheet in the workbook.

Any help?

James

 

[jimmywanna]

It was exactly that mate, it makes sense now.

thanks for replying though mate.

jim