Selecting Sheets within a Macro
 

Several requests:

1. How do I auto-run a macro that I created when I launch a spreadsheet?
2. How can I pause the macro so that I can select/open another file to run
the macro against?
3. After I open the file, how can I get the macro to change the worksheet
tab from the current name to "Sheet 1"?

Thanks

Ernie

Selecting Sheets within a Macro
 

Hi
1. Put your code in the workbook_open event of your workbook or rename your
macro to auto_open()
2. Have a look at the wait method and workbooks.open in the vBA help
3. activesheet.name="sheet1"

"esersen" wrote:

Several requests:

1. How do I auto-run a macro that I created when I launch a spreadsheet?
2. How can I pause the macro so that I can select/open another file to run
the macro against?
3. After I open the file, how can I get the macro to change the worksheet
tab from the current name to "Sheet 1"?

Thanks

Ernie