Running Code Automatically

  • Thread starter Thread starter Bruno
  • Start date Start date
B

Bruno

Hi All:

How can I run code automatically in Excel XP when I open a spreadsheet?

Thanks in advance,
Bruno
 
Place your code in the ThisWorkbook Object. Using the Workbook_Open Sub.
 
Bruno,

Another way.......
If you already have a Sub...let's say
Sub Macro1()
rename it to
Sub Auto_Open()

John
 
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

Running SPSS-Syntax using Excel VBA (Excel 2013) 0
Alt codes 4
Excel Import External Data by Date Automatically 0
Conversion to XP causing problems 2
Automatically input file names from a directory to Excel sheet? 7
Status Bar shows "Calculate", but calculation is set to Automatic 1
Run Sub automatically on periodic basis 2
Excel XML Auto Column Width 0

Back
Top