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
|