Running Code Automatically

Bruno · Jan 31, 2004

Hi All:

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

Thanks in advance,
Bruno

Terry Frost · Jan 31, 2004

Place your code in the ThisWorkbook Object. Using the Workbook_Open Sub.

John Wilson · Jan 31, 2004

Bruno,

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

John