Automatic Macros

[Chris]

I have a macro that I would like to automatically open
when my workbook opens (no, I'm not writing a virus ).
I know it can be done, but can't figure out how to do it.
I am working in Excel 2000.

Any help would be greatly appreciated

Thanks

 

[Chip Pearson]

Chris,

Name the macro Autpen. Alternatively, you can put the
following code in the ThisWorkbook code module (not a standard
code module):

Private Sub Workbook_Open()
' your code here
End Sub



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Peter McCloskey]

I should have said that it is several macros, all stored in the personal.xls
file. What I don't understand is why the file has stopped loading at
startup as it is still in the Xlstart folder.
Peter