Selecting Sheets within a Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro on All Sheets Q 8
Error Message - Macro to Unlink MS Queries from Workbook 0
forcing specific sheet opening upon launch of .xlsx file 4
Sheet selection on Autoclose 2
Macro Related to Paste Values 2
Run macro from active workbook whose name keeps changing 20
Unable to change ActiveSheet within Workbook_Open 2
Macro to generate powerpoint slides 43

Back
Top