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" wrote in message
...
Hi All:

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

Thanks in advance,
Bruno

Bruno,

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

John

"Terry Frost" wrote in message
...
Place your code in the ThisWorkbook Object. Using the Workbook_Open Sub.


"Bruno" wrote in message
...
Hi All:

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

Thanks in advance,
Bruno