Automate macro

[Marc]

Hi,
Is it possible to have a macro run automatically when a
particular spreadsheet opens?
I'm in Excel 2000 and Windows 98.

Thanks,

Marc

 

[John Wilson]

Marc,

Two ways.....

1st is to name your macro Autpen

Sub Autpen()
'your code here or your sub name here
End Sub

or place your code (or a call to your sub) in the Workbook_Open Event
Double click on the "ThisWorkbook" in the "Projects" window and copy
and paste the following:

Private Sub Workbook_Open()
'your code here or your sub name here
End Sub

John

 

[Marc]

Thanks John

That worked! And thanks for such a quick response.

Marc