Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Macro in selecting sheets. | New Users to Excel | |||
Selecting sheets | Excel Discussion (Misc queries) | |||
selecting sheets | Excel Programming | |||
Changing the value in multiple sheets without selecting those sheets | Excel Programming | |||
selecting sheets | Excel Programming |