recorded macro

[Peterfc2]

Application.Run "crt2.xls!newmonthly_Button2_Click"
Sheets("sep").Select
Application.Run "crt2.xls!newmonthly_Button2_Click"
Sheets("oct").Select
Application.Run "crt2.xls!newmonthly_Button2_Click"
Sheets("nov").Select
Application.Run "crt2.xls!newmonthly_Button2_Click"
Sheets("dec").Select
Application.Run "crt2.xls!newmonthly_Button2_Click"
Sheets("jan").Select
Application.Run "crt2.xls!newmonthly_Button2_Click"
Sheets("feb").Select
Application.Run "crt2.xls!newmonthly_Button2_Click"
Sheets("mar").Select
Application.Run "crt2.xls!newmonthly_Button2_Click"
Sheets("apr").Select
Application.Run "crt2.xls!newmonthly_Button2_Click"
Sheets("may").Select
Application.Run "crt2.xls!newmonthly_Button2_Click"
Sheets("aug").Select
Range("J2").Select

I recorded the macro above which which runs macro buttons on sheets Aug to Sep.

When I save the spreadsheet as crt1 it does not work. Solution please

 

[MrsPen]

Hi Peter,

If you change the name of the spreadsheet, you would need to change each line of code that references "crt2.xls" to the new file name. In this case it would read "crt.xls!newmonhtly_Button2_Click".

Cheers!

 

[mikerickson]

Where is newmonthy_Button2_Click?

if it is in a normal module you could use

Application.Run "newmonthy_Button2_Click"

It would also be faster if newmonthy took a sheet as its argument so you could avoid all that selecting. Could you post newmonthy...

 

[Peterfc2]

Where is newmonthy_Button2_Click?

if it is in a normal module you could use

Application.Run "newmonthy_Button2_Click"

It would also be faster if newmonthy took a sheet as its argument so you could avoid all that selecting. Could you post newmonthy...[/QUOTE]

Sorted! just edited out crt2.xls! and it works fine. Thanks all.